How to Remove Leading and Trailing Spaces in Excel 

What a blessing to have you share your knowledge here. These tricks might be basic to a pro, or to someone who uses Excel on a regular basis; but for newbies or people who use it sporadically, every little thing can turn into a very time consuming issue. Anyway, just want to tank you. Super helpful!

i'm not an english native speaker and i was reading doc about leading/trailing spaces in linux code and i reached here. I also use excel for basic stuff, this trim feature will help a lot - nice video mate

You are the god of Excel. The Clean function helped me to save lots of time. Thank you.

Thank you so much! Subscribed.

You are the coolest excel "Guru" iv'e come across! Thanks for sharing!

Sumitji Your videos are always superb and carry a unique content with simplicity which is your forte. Thanks a lot. It would be better if you provide a link to download the worksheets used in your demo, to follow along.

Thank you

YOU ARE AWESOME!!

Thanks sir very helpful video

Can you tell me how to remove only trailing spaces ? But dont remove inbetween or leading spaces .

Thanks alot

This is really great

LOVELY

What if this trim formula is not working I have tried and put it many times with pasting as values but again spaces are copied? Thanks in adv

very inportant information

great function...Thank you

I have data like 12 /2021. How to remove the space between 12 and forward slashe.

Great

Hi sir I am Anushka I want it learn a excel.. from zero level I am not know about excel anything I scroll your all vedio I am confused which vedio is a starting excel course....... zero level knowledge about excel I can't find plz help me I am waiting for your messages plz sir help me I am waiting your message first vedio of excel

This does not work on me...

0:31

This video is totally BLUR, Cannot visible what u r demonstrating... Only through audio able to cope up with the flow of explanation