Remove space

[Anonymous]

Hi All,

Need your help.

i have query looking like below. my problem is there is a space in second row, SS

in excel, i do select the column and ctrl+F , replace > find what :  'space' > Replace with : put nothing.

do you know how to remove the space in PBI?

thank you,

CL

[Fowmy · Accepted solution]

@Anonymous 

You can right-click on the column, select TRIM then CLEAN.

You can share your data file as a sample.


____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[amitchandak]

@Anonymous , right click on the column in edit query mode you have a replace option. Work the same way as excel

refer

https://yodalearning.com/tutorials/learn-how-replace-values-power-query/

or add a step

https://docs.microsoft.com/en-us/powerquery-m/text-replace

[Anonymous]

@amitchandak  thanks for your info..

maybe it's not a space.. it doesn't work in power query..