Remove commas from a column

[moram]

I have a spreadsheet consisting of a list of emloyees (over 500 employess).
How can I format the column in a way that I remove the commas (Jones, Jimmy)?

 

[sawedoff]

How about Edit - Replace
In the Find what field, put a comma
and in the Replace with field, leave blank, hit Replace all, and you should be done.

Sawedoff

Give me ambiguity or give me something else.

 

[SkipVought]

Hi,

Do you really want to REMOVE the commas leaving "Last First" in the SAME CELL?

You could use the Data/Text to columns wizard to parse the last and first names into separate columns.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com