Forum Discussion
lastnn30
Post Patron
Post Patronseprate number with - (dashes) using power query
Hi I have a number like this 123456789. Can I use power query only (no formula) to trasfer it to 123-456-789. Thank you very much for the help in advance.
Here is one clickety-click way
If you need the orignal also, just duplicate the original column before applying the steps
PaulDBrown
Community Champion
Community ChampionHere is one clickety-click way
If you need the orignal also, just duplicate the original column before applying the steps
JorgePinho
Solution Sage
Solution SageHi PaulDBrown ! Pretty nice demonstration 🙂 Can you tell me which program did you use to record it ?
- PaulDBrown
- JorgePinho
Thank you so much!