Software

Ask something
Discussion Locked

Excel space removal

0 helpful
5 replies

by johntstarnes

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How would I remove the space between the last name, first name in excel? example of names in column: Smith, John change to Smith,John. I would want to apply this change to all names in a column.

5 replies

by don christner

Temporarily insert a column next to your name column, in my example I will say the name column is A and my new column is B. In column B enter the following: =REPLACE(A1,FIND(" ",A1),1,"")

Then drag that formula down the entire column length. Column B now does not have spaces in it. Now select column B and copy it. Then go to column A and select paste special and select values. Now coulmn A has no spaces and you can delete column B. If you do not do the last step, you can not delete column A without losing your changes.

Don

by dklippert

The quick and dirty way is to highlight the column, and use Edit>Replace. In the Find what box put a comma and the hit the space key once. In the Replace with box just put a comma. Replace all.

This discussion is closed to new replies.