Write a count like 15 out of 20
Turn a count of 15 and a total of 20 into 15 out of 20, keeping the real numbers.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The count, as typed. | "15" |
| 2 | &" out of "& | Adds the words "out of" between the numbers. | "15 out of " |
| 3 | B8 | The total, as typed. | "15 out of 20" |
The numbers are kept as they are, so 6 out of 8 never becomes 3 out of 4.
=A8&" out of "&B8How 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 numbers. Paste counts into column A and totals into column B of the Template tab. The statements fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Check that each count and its total cover the same group and the same time.
Microsoft's help: Combine text from two or more cells



