View Single Post
 
Old 04-30-2020, 06:20 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

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.
Reply With Quote