Return a short stored ID as text
Turn the number 123 into the text 123. Text like 000123 and empty rows stay as they are.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="" | Checks whether the cell is empty. | No, it has 123 |
| 2 | A8&"" | Adds nothing, which turns a number into text. | "123" |
| 3 | IF( … ) | Leaves an empty cell blank, otherwise uses part 2. | "123" |
Read it left to right. Text IDs pass through unchanged. The IDs here are made-up.
=IF(A8="","",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 IDs. Paste your IDs, numbers or text, into the green column of the Template tab. The text versions fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This adds no zeros. If an ID already lost its zeros as a number, check it against the source.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Keep missing-ID markers blank
NULL → blank; 000000001 → 000000001 (zeros kept)
Get the template →
Pad a code with zeros to a set width
A7 + width 4 → 00A7
Get the template →
Remove a trailing .0 from an ID
012345678.0 → 012345678
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →