Read text like 12.5 percent as a rate
Turn the words 12.5 percent into the number 0.125.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXTBEFORE(A8," percent") | Keeps the number before the word percent. | "12.5" |
| 2 | "." | A period marks the decimals. | "12.5" |
| 3 | "," | A comma groups thousands, like 1,250. | "12.5" |
| 4 | NUMBERVALUE( … ) | Reads the text as a number. | 12.5 |
| 5 | /100 | Divides by 100 to make a rate. | 0.125 |
The word must be lowercase percent after one space. To show 12.5% again, use Percentage format.
=NUMBERVALUE(TEXTBEFORE(A8," percent"),".",",")/100How 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 percentages. Paste text like 7.25 percent into the green column of the Template tab. The numbers fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only for text that spells out percent. Text like 12.5% or 12.5 Percent turns amber.
Microsoft's help: NUMBERVALUE function
OTHER ROUTES YOU MIGHT LIKE

Turn mixed percent units into rates
12.5 Percent points → 12.50% as a rate
Get the template →
Turn a 2x multiplier into percent change
2x multiplier → 100% change
Get the template →
Round a rate to chosen percent decimals
12.34560% at 2 percent decimals → 12.3500%
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →