removing random spaces

[shylomathew]

how can i remove random spaces between '-' and numbers?

Example of unclean data that i have -

-           5

-   3

-              56

-                                 87

[Anonymous]

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.

[shylomathew]

Did not work as the spaces are not in the beginning or end. And it is not control characters, too

[m_alireza]

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 now

[shylomathew]

This replaces only 1 space at a time