How do I convert '$1,234.50' text to a number?

=VALUE(SUBSTITUTE(SUBSTITUTE(A2,"$",""),",","")) returns 1234.5. Split Amount & Currency parses it for you, along with €, £, ₹ and trailing ISO codes.

How do I read (250) as a negative number?

Accounting exports wrap negatives in parentheses. Split Amount & Currency reads "(250)" as -250 automatically; a plain VALUE() formula returns an error on it.

Home › Excel Guides › Split Amount and Currency in Excel

How to Split Amount and Currency in Excel

A money column that arrives as text — $1,234.50, € 99, 1,000 USD, (250) — won't SUM. Here's how to split it into a clean number you can total and a currency code you can group by.

Last updated: August 2026

Money text		Amount	Currency
$1,234.50	→	1234.5	USD
€ 99	→	99	EUR
(250)	→	-250	USD

Method 1 — SUBSTITUTE + VALUE

=VALUE(SUBSTITUTE(SUBSTITUTE(A2,"$",""),",","")) strips a $ and thousands commas to a number.
Add a nested SUBSTITUTE for every other symbol you expect (€, £, ₹…).
For the currency, map the symbol with IF or a small lookup table.

Two formulas, and both grow with every currency. Worse, VALUE("(250)") returns #VALUE! — accounting negatives in parentheses need their own IF, and a stray space or non-breaking space breaks the parse.

Method 2 — Text to Columns

Only works when a single delimiter cleanly separates the number and the code (e.g. 1000 USD). Symbol-prefixed values like $1,000 or European formats defeat it.

The 1-click way — Tellsheet

Split Amount & Currency reads a messy money column and adds two clean columns: a numeric Amount you can actually SUM, and a Currency code (USD, EUR, GBP, INR…). It recognizes symbols ($ € £ ₹ ¥) and trailing ISO codes, strips thousands separators, and reads accounting-style (250) as −250. Previews first and is revertable. Pairs with Currency Converter and Convert Text to Number.

Frequently asked questions

How do I split a currency amount in Excel?

SUBSTITUTE + VALUE for the number and a symbol lookup for the code, or Tellsheet's Split Amount & Currency in one click.

How do I turn "$1,234.50" into a number?

=VALUE(SUBSTITUTE(SUBSTITUTE(A2,"$",""),",","")), or let Split Amount & Currency parse it with the symbol.

How do I read (250) as negative?

Split Amount & Currency reads parentheses as a negative automatically; VALUE() errors on it.

Does it handle € and £?

Yes — it recognizes common currency symbols and 3-letter ISO codes.

Related Excel guides

Make a money column SUM-able

Split Amount & Currency separates the number from the code — reading (250) as −250 — right inside Excel.

Get Tellsheet free See pricing