How to Remove Extra Spaces in Text Cells in Excel

preview_player
Показать описание
In this video, I show you how to remove unneeded spaces in a cell using the Trim formula in Excel 2016 (should be similar for most versions of Excel). This is handy if you need to remove spaces at the beginning or end of text, or if there are double spaces between some words. This will not remove necessary spaces between words such as "New York" but will correct extra spaces such as " New York " with one simple formula.

Don't forget to subscribe to my channel for more tutorials!

Thanks for tuning in!
Рекомендации по теме
Комментарии
Автор

Thank YOU! You saved me tons of time on a projects i was working on. I am a subscriber now :P

OvidianHEX_
Автор

Thanks! that was very helpful. Saved me a lot of time.

jfk
Автор

This video is very helpful for me.Thanks!

irfanshahzad
Автор

Than you! This was great!! You're an awesome teacher!

thevictorc
Автор

Fentastic I just love u r passionated it up

bharathij