Replace characters in a string

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

FAQ

Thread Tools

Display Modes

04-30-2020, 06:20 PM

Marcia

Windows 7 32bit Replace characters in a string

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

I think the SUBSTITUTE formula will make me replace "qz" to hyphen instead of the several A E I O U. I will try this approach.
I'm so new to power query, I didn't know about the Capitalize Each Word option.

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 05:10 AM.