Forum Discussion
removing random spaces
how can i remove random spaces between '-' and numbers?
Example of unclean data that i have -
| - 5 |
| - 3 |
| - 56 |
| - 87 |
4 Replies
Hi shylomathew ,
Open Power Query Editor
Right click on the column > Replace Values
in Value to Find, enter the space bar
in Replace with, dont put anything.
Click ok.
The spaces should be gone nowThis replaces only 1 space at a time
Hi shylomathew ,
Trim & clean might help.
Please kindly refer to
Trim Vs. Clean in Power BI and Power Query - RADACAD
They are done in Power Query.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Did not work as the spaces are not in the beginning or end. And it is not control characters, too
