Turn fraction text into a number
Read 1/2 typed as text as the number 0.5.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXTBEFORE(A8,"/") | Keeps the top number, before the slash. | "1" |
| 2 | / | Divides the top number by the bottom number. | 1 divided by … |
| 3 | TEXTAFTER(A8,"/") | Keeps the bottom number, after the slash. | "2", so 0.5 |
Excel reads both pieces as numbers and divides them. A minus sign on the top number is fine.
=TEXTBEFORE(A8,"/")/TEXTAFTER(A8,"/")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
Mixed numbers like 1 1/2, units and spaces need a look first. Keep the fraction cells as text, or Excel may make 1/2 a date.
Microsoft's help: TEXTBEFORE function
OTHER ROUTES YOU MIGHT LIKE

Read mixed fractions like -1 1/2
-1 1/2 as text → -1.5
Get the template →
Combine a whole number and a fraction
1 and 1/2 → 1.5
Get the template →
Build a fractional house-number label
12 and 0.5 → 12 1/2
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →