Start a conversation

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"


Choose files or drag and drop files
Helpful?
Yes
No
  1. Joshua Iacobozzi

  2. Posted
  3. Updated

Comments