Getting rid of excess spaces in Excel using TRIM function


PC Tipster's Blog

Sometimes you are working on a spreadsheet with lots of text in it and sometimes too much spaces as shown below.

David           Smith                 Jr.
Mary  Johnson
Philip                         Martin

The TRIM function will get rid of the excess spaces.


View original post