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
The separator remover strips copied formatted numbers down to plain digits: for example 1,234,567, 1 234 567, and 123-456-789 copied from spreadsheets or documents all clean to 1234567, 1234567, and 123456789 in one pass.
Note: every character except digits (and the symbols you choose to keep) is treated as a separator; turn off keep leading zeros and 007 becomes 7.
Note: every character except digits (and the symbols you choose to keep) is treated as a separator; turn off keep leading zeros and 007 becomes 7.
How to use
- Paste the formatted numbers into the input box.
- Choose the scope: merge all lines into one string and clean together (useful when a long number wraps across lines), or clean each line separately, producing one result per line.
- Tick whether to keep the decimal point and minus sign; unticked, both are stripped as separators too.
- Click Start; the text box on the right outputs the cleaned result, the table below shows original to cleaned pairs line by line (copyable in place), and a CSV download is available.
Message board
All messages →-
No one has spoken up yet — want to go first?