removing commas

[markster]

Column A of my spreadsheet contains a list of names separated by a comma (i.e Smith, James). Is there a way to easily remove all of the commas as I need to do a VLOOKUP and my lookup sheet does not have commas?

Cheers
Mark

 

[sweater_vests_rock]

markster.

1) highlight the column
2) CTRL+H to bring up the Find/Replace dialog
3) in the dialog box, Find: ",", Replace: "" (no need for quotes)
4) Click "Replace All"

this will remove all the commas from the column.

cheers.ben.

 

[barry houdini]

Just use Edit > Replace and replace comma with nothing