Skip to content
Tags

Getting rid of excess spaces in Excel using TRIM function

April 15, 2015

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.

 

Advertisements

From → Excel

One Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: