Remove trailing spaces

[Centaur]

Hello, 

How could I remove the trailing spaces in my table field named Vendor?  

I can filter for vendors with a space at the end but I dont know how I can remove the space at the end.  

I am not sure what else woudl need to be know but feel free to reach out.  

I know I can use trim in excel but I want to use power query to do this. 

I am a novice user. 

thank you

[Centaur]

that was perfect!  thank you very much!

[serpiva64 · Accepted solution]

Hi,

here you find the command you need (trim)

provide a sample data if you need something else

If this post is useful to help you to solve your issue consider giving the post a thumbs up 👍 and accepting it as a solution !

[kapplebee]

Thank you for the screen shot, this did exactly what I needed.