Forum Discussion
Removing certain characters
Hi, how can I remove certain charaters in Power Query. For example, below I want to remove the ":A:" so its just the numerical digits.
You can just select that column in the query editor, and click on Replace Values on the home tab. In the top box put :A: and leave the replace with box empty.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
3 Replies
You can just select that column in the query editor, and click on Replace Values on the home tab. In the top box put :A: and leave the replace with box empty.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat thank you!!!
is the string will remain :A: you can use SUBSTITUTE([column],":A:","") this will strip the ":A:" from your string
