Read fractions with a fraction slash
Read 1⁄2, written with the slanted fraction slash, as the number 0.5.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | VALUE(TEXTBEFORE(A8,UNICHAR(8260))) | Keeps the top number, before the fraction slash. | 1 |
| 2 | / | Divides the top number by the bottom number. | 1 divided by … |
| 3 | VALUE(TEXTAFTER(A8,UNICHAR(8260))) | Keeps the bottom number, after the fraction slash. | 2, so 0.5 |
UNICHAR(8260) is the fraction slash ⁄, not the keyboard slash /. A minus sign on the top number is fine.
=VALUE(TEXTBEFORE(A8,UNICHAR(8260)))/VALUE(TEXTAFTER(A8,UNICHAR(8260)))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 list. Paste fractions like 3⁄4 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
A fraction typed with an ordinary keyboard slash turns amber here. Mixed numbers, units and spaces need a look first.
Microsoft's help: UNICHAR function
OTHER ROUTES YOU MIGHT LIKE

Read only plain fraction text like 3/4
3/4 → 0.75; 3/0 → Review: check the fraction
Get the template →
Rewrite a fraction at a new denominator
1/2 in eighths → 4/8
Get the template →
Write a value in eighths like 4/8
0.5 → 4/8
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →