Link to home
Start Free TrialLog in
Avatar of RAE
RAE

asked on

How can I remove blank spaces in Excel?

I have a very large file I imported into Excel but am having problems sorting it because many entries in cells begin with a space. How can I mass remove these unwanted spaces?
Avatar of Brian Mulder
Brian Mulder
Flag of Netherlands image

Hi RAE,

-lets say data start at row 2
-you can insert a column in front of the offending column say column A which will then become the B column
-then add this formula =LTRIM(B2) to the new column in A2
-now copy this formula down till the end of the column to trim
-to round it up select column A completely choose copy
-then goto the second column choose paste special | only values
-then delete the first column again

be sure to make a copy first of this sheet but it will work like this

HTH:Bruintje
ASKER CERTIFIED SOLUTION
Avatar of jklmn
jklmn

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RAE
RAE

ASKER

Thanks very much! It worked very well. (When I tried bruintje version I kept getting a #NAME? error)