Replace characters in a string

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Replace characters in a string

FAQ

Thread Tools

Display Modes

05-04-2020, 05:15 AM

Marcia

Windows 7 32bit Replace characters in a string

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Quote:

Originally Posted by p45cal

It would be a lot cleaner to do this in Power Query, since you're already using it.

Capitalize Each Word in power query was mentioned earlier but I was squeezed of precious minutes to find it out. Now that I had time to explore it, I found out that I could do away with the several helper columns in the data source. Again, thank you.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract all characters from the nth number of a string	Marcia	Excel	2	02-24-2020 05:15 PM
Wildcard replace any string in context with a specified string	wardw	Word	7	05-07-2018 09:13 AM
Replace characters in a string	Anthon	Excel Programming	1	11-03-2016 12:48 AM
find a set of characters in a string and return a 0 (zero) if not found	MaineLady	Excel	2	11-05-2015 03:23 PM
Retrieve characters after nth occurence of a string	veedee	Excel	5	06-16-2014 03:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:37 AM.