EXCEL Remove Spaces Before and After Text

Let Sharyn show you two quick ways to remove extra spaces in an Excel cell.

Thank you

Very good! Thank you Sharyn for this tutorial. I guess your first 'like' comes from me. 😊😊

Thanks

thank you. Such a big help

It isn't working for me. I have a column of over 500 links to our companies' internal files and I can't get that 1 trailing space to go away. To be clear all these files are coming from 1 agent. The files from other agents I can trim just fine. They are all on the same spreadsheet when they come to me to work. So confused.

Very helpful and explanatory video! Thanks so much!

Ur accent is Australian

How to trim spaces from the start of the text?

If we want only remove space form the right "Steve Job "" then?

Thank you so much,this has really helped me and saved my time today.

Thanks much, it is very useful for cleaning data

Helpful. Thanks

Thank you. This has got to be the biggest frustration in Excel! I was just about to give up even after trying the TRIM function which didn't delete all the spaces. I used the =RIGHT function to identify the extra spaces at the end of the cells and had to manually delete them!