Remove Commas from Numbers
Strip the commas, spaces and dashes that separate digits — 1,234,567 becomes 1234567. You can keep the decimal point and the minus sign, and choose whether to clean the whole text or each line.
Type:
Separator:
Recognition Options:
Calculation Result
Download CSV
| Count | Original | Cleaned |
|---|
Introduction to the tool and how to use it
Number Separator Remover turns decorated numbers copied from spreadsheets or documents back into plain digits — 1,234,567, 1 234 567 and 123-456-789 all become 1234567, 1234567 and 123456789.
Steps:
1. Paste your numbers, separators and all;
2. Choose the scope: "merge everything into one" joins every line before cleaning (handy when a single long number wrapped), while "one result per line" cleans each line separately;
3. Decide whether to keep the decimal point and the minus sign — untick them and they are treated as separators too;
4. Click Run. The text box shows the cleaned values and the table below gives the original-to-cleaned comparison (copyable in place); CSV export is available.
Note: every character other than digits (and the signs you chose to keep) counts as a separator. Untick "keep leading zeros" and 007 becomes 7.
Steps:
1. Paste your numbers, separators and all;
2. Choose the scope: "merge everything into one" joins every line before cleaning (handy when a single long number wrapped), while "one result per line" cleans each line separately;
3. Decide whether to keep the decimal point and the minus sign — untick them and they are treated as separators too;
4. Click Run. The text box shows the cleaned values and the table below gives the original-to-cleaned comparison (copyable in place); CSV export is available.
Note: every character other than digits (and the signs you chose to keep) counts as a separator. Untick "keep leading zeros" and 007 becomes 7.
Message board
All messages →-
No one has spoken up yet — want to go first?