Forum Discussion
lastnn30
Post Patron
4 years agoseprate 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.
- 4 years ago
Here is one clickety-click way
If you need the orignal also, just duplicate the original column before applying the steps
JorgePinho
Solution Sage
4 years agoCheck this out: https://blog.crossjoin.co.uk/2015/12/03/the-text-format-function-in-power-bipower-query-m/