Forum Discussion
Remove space
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
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 🙂
3 Replies
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 🙂
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
amitchandak thanks for your info..
maybe it's not a space.. it doesn't work in power query..
