How to Remove Comma in Excel Using Formula (2 Ways)

Method 1 – Using SUBSTITUTE Function to Remove Comma in Excel

Steps:

• Enter the following formula in the formula bar.

• Press Enter and use the Autofill tool for the entire column.

• All commas will be removed.

Method 2 – Applying Excel NUMBERVALUE Function to Remove Comma

Steps:

• Enter the following formula into the formula bar.

• Press Enter, use the Autofill tool to fill in the remaining cells.

• All commas will be removed.

Download Practice Workbook

Related Articles

• How to Change Comma Separator in Excel
• How to Remove Inverted Comma in Excel
• How to Remove Commas in Excel from CSV File
• How to Remove Comma from Currency in Excel

<< Go Back To Remove Comma in Excel | Data Cleaning in Excel | Learn Excel