how to remove all spaces in an EXCEL column

How can I remove all spaces (trailing, leading,...) for a EXCEL spreadsheet coloumn?
HojoformoAsked:
Who is Participating?
 
Patrick MatthewsCommented:
Hojoformo,

BTW, you should delete that duplicate question you opened...

Regards,

Patrick
0
 
Patrick MatthewsCommented:
Hello Hojoformo,

Here is a really simple way:

1) Select your column(s)

2) Hit Ctrl+H to get the find/replace dialog

3) In the find, type a single space.  In the replace box, make sure it is totally empty

4) Click Replace All

Regards,

Patrick
0
 
Calvin BrineCommented:
1.  Insert a column beside your column you need to remove spaces from.
2.  Enter this formula and copy it down to the bottom of the column "=Trim(B2)", where B2=Your text and spaces.
3.  Copy the new column and pastespecial Values over the original column.
4.  Delete the column with the formula.
HTH
Cal
0
 
Patrick MatthewsCommented:
Hojoformo,

Please note that me suggestion replaces ALL spaces.  Cal's removes leading and trailing spaces, and any
internal spaces of 2+ are scaled back to a single space.  Only you know which of those is what you really
wanted :)

Regards,

Patrick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.