Removing commas in Excel
To remove all commas in an Excel spreadsheet, use the following steps:
- Click the Find & Select > Replace under Home tab to open the Find and Replace dialog box
- Click the "Replace" tab
- In the "Find what:" box, enter a single comma only.
- Do not enter anything in the "Replace with:" box.
- Finally, click the Replace All button in the bottom left of the "Find and Replace box"