Remove Thousand Separator
Batch remove thousand separators from numbers
Tool Guide
About This Tool
The online tool for removing thousands separators from numbers can quickly batch-remove thousands separators from a list of numbers, making them better conform to domestic number-display conventions.
A thousands separator is actually the comma in a number. By Western convention, people insert a symbol into numbers to prevent the value from being hard to read when it has too many digits. So people insert a comma—that is, a thousands separator—into a number every three digits, to make the value easier to recognize.
Very often, in Excel files downloaded from elsewhere, many columns involving quantities carry comma thousands separators and are displayed as text cells, which makes it inconvenient for the machine to compute totals. You can use this tool to quickly replace the thousands separators, converting the values into numeric type for easy numerical calculation.