Views:

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"