Thread
: [Solved]
Replace characters in a string
View Single Post
04-30-2020, 06:20 PM
Marcia
Windows 7 32bit
Office 2013
Expert
Join Date: May 2018
Location: Philippines
Posts: 527
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.
Marcia
View Public Profile
Find all posts by Marcia