Read amounts in the required currency
Turn USD 1,234.56 into 1234.56 when USD is required. Other codes get flagged.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | LEFT(A8,4)=B8&" " | Checks the amount starts with the required code. | TRUE |
| 2 | NUMBERVALUE(MID(A8,5,99),".",",") | Reads the rest as a number. A period marks decimals. | 1234.56 |
| 3 | "Review currency" | The message when the codes don't match. | Not used for row 8 |
| 4 | IF( … ) | Picks the number or the message. | 1234.56 |
Capitals don't matter: usd matches USD. Nothing is converted between currencies. The amounts are made-up.
=IF(LEFT(A8,4)=B8&" ",NUMBERVALUE(MID(A8,5,99),".",","),"Review currency")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own amounts. Paste amounts like USD 1,234.56 into column A and the code you need into column B of the Template tab.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
A flagged row is in another currency. Check it by hand before you use the amount.
Microsoft's help: NUMBERVALUE function
OTHER ROUTES YOU MIGHT LIKE

Turn currency text into a number
-$1,234.50 minus the $ label → -1234.5
Get the template →
Read amounts like 1.234,56 as numbers
1.234,56 € → 1234.56
Get the template →
Read space-grouped amounts
1 234,56 EUR → 1234.56
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →