If you imported a comma-delimited file into Excel or if you are faced with a spreadsheet that separates first and last names with commas, you will likely want to clean it of extraneous commas. Although you could manually delete the commas if you have just a few, this can become tedious with a larger file. The most straightforward approach is to use Excel's Find and Replace feature.
Open the Excel workbook that has names with commas.
Click the "Home" tab on the ribbon and then click "Find & Select." Select "Replace" from the menu.
Video of the Day
Enter a comma in the "Find what" box. Leave the "Replace with" box blank.
Click "Replace All" if you want to remove all the commas automatically or click "Find Next" to go through your worksheet one by one. Every time Excel highlights a comma, click "Replace" if you want to remove it or click "Find Next" if you want to skip it and go to the next occurrence. The latter option is useful if you just have a few commas you want to remove.