Forum Discussion
Solved
Trim not working in Power Query
Hi all
How can I get rid of the end spaces in strings like this:
Planta Reyes ;Planta San Juan Del Río;Planta Villahermosa ;
I tried using trim but is not removint them.
Solution should be:
Planta Reyes;Planta San Juan Del Río;Planta Villahermosa;
Thanks.
o59393 , I think for that you need to replace -> ;<- with ->;<- , Arrows use to show space
Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk
pls try this
2 Replies
o59393 , I think for that you need to replace -> ;<- with ->;<- , Arrows use to show space
Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk
pls try this