Removing certain characters

[PowerBI123456]

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. 

[rubinboer]

is the string will remain :A: you can use SUBSTITUTE([column],":A:","") this will strip the ":A:" from your string

[mahoneypat · Accepted solution]

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

[PowerBI123456]

@mahoneypat thank you!!!