Guide · StatementTidy
How to remove currency symbols from numbers (and keep the currency)
Short answer
In Excel, Ctrl+H or =VALUE(TRIM(SUBSTITUTE(A2,"AED",""))) strips one symbol at a time. That works for a single-currency column but throws away information when currencies are mixed. StatementTidy moves the currency into its own column (USD, EUR, AED, GBP…) and leaves the amount a real number, handling codes, symbols, Dhs and Arabic د.إ, before or after the number, with or without a space.
Last updated · by Mumshad Jawad
Why this happens
A cell like AED 1,120.00 looks like a number but is text. Card statements and travel bookings make it worse by mixing currencies in one column, writing the symbol before or after the number, and using local decimal commas (€ 312,40). Removing the symbol is only half the job: you also need to know which currency each amount was in.
Some symbols are ambiguous. $ could be US, Canadian, Australian or Singapore dollars, so StatementTidy keeps it as $ rather than guessing; unambiguous forms such as US$, A$ or € become ISO codes.
Real example: before and after
The rows below are fictional. The “after” table is not a mock-up: this page ran them through StatementTidy’s cleaning engine (the same clean.js the extension uses, v1.0.1) with its default options, and shows exactly what you would export.
| Date | Merchant | Amount |
|---|---|---|
| 03/09/2026 | APPLE.COM/BILL | US$ 9.99 |
| 11/09/2026 | BOOKING.COM | € 312,40 |
| 14/09/2026 | NOON.COM | AED 1,120.00 |
| 16/09/2026 | CAREEM RIDE | Dhs 38.50 |
| 19/09/2026 | TFL TRAVEL | £ 12.80 |
| 27/09/2026 | ADNOC 512 AL BARSHA | 210.00 AED |
| Date | Merchant | Amount | Amount currency |
|---|---|---|---|
| 2026-09-03 | APPLE.COM/BILL | 9.99 | USD |
| 2026-09-11 | BOOKING.COM | 312.40 | EUR |
| 2026-09-14 | NOON.COM | 1120.00 | AED |
| 2026-09-16 | CAREEM RIDE | 38.50 | AED |
| 2026-09-19 | TFL TRAVEL | 12.80 | GBP |
| 2026-09-27 | ADNOC 512 AL BARSHA | 210.00 | AED |
- Date column converted to ISO YYYY-MM-DD (DD/MM detected)
- Currency moved to its own column (Amount currency)
Open this example in the live demoEdit the rows, paste your own table, toggle options. Nothing is uploaded.
How to fix it by hand in Excel
One currency in the column
Select the column, Ctrl+H, find AED and replace with nothing, then Data → Text to Columns → Finish to turn the text into numbers. As a formula:
=VALUE(TRIM(SUBSTITUTE(A2,"AED","")))
To keep showing the currency without making the cell text, use Format Cells → Custom → "AED" #,##0.00.
Mixed currencies
Extract the code first into a helper column (for three-letter codes at the start: =LEFT(TRIM(A2),3)), then strip it. Symbols such as € or £ need their own rule, and a decimal comma needs NUMBERVALUE (see the European numbers guide).
How to fix it in one click with StatementTidy
- Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
- Open the page. A card statement, multi-currency wallet, booking history or invoice list.
- Click the StatementTidy icon. Keep “Put currencies in their own column” on. Each amount column with currencies gets a “… currency” column next to it.
- Copy for Excel. Sum or pivot by the currency column; amounts are plain numbers.
Get StatementTidy free for ChromeTry it on a sample statement
Questions
Which currencies does it recognise?
Over 60 ISO codes (AED, SAR, QAR, KWD, BHD, OMR, USD, EUR, GBP, INR, PKR, JPY, CNY, CHF, and more) and symbols such as €, £, ₹, ₺, zł, Kč, Dhs and the Arabic Gulf currency symbols. Ambiguous symbols ($, ¥, kr, Rs) are kept as written.
What if the currency is only in the header, like “Amount (AED)”?
Then the cells are plain numbers already and the header keeps the currency. When some cells carry a symbol and others don’t, the empty currency cells are filled from the header, or from the column’s only currency.
Does it convert between currencies?
No. It never changes amounts or applies exchange rates; it only separates the currency from the number.