Label a contact value with its type
Turn phone and 201-555-0123 into phone: 201-555-0123, and flag a missing type.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | B8="" | Checks whether the contact value is empty. | FALSE |
| 2 | IF(A8="", … ) | Flags a value that has no contact type. | Has a type |
| 3 | A8&": "&B8 | Writes the type, a colon and the value. | "phone: 201-555-0123" |
| 4 | IF( … ) | Says No contact value when empty, else uses part 2. | "phone: 201-555-0123" |
Read it left to right. The type is never guessed from how the value looks. The numbers here are made-up.
=IF(B8="","No contact value",IF(A8="","Review missing contact system",A8&": "&B8))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 contacts. Paste each contact type, such as phone or fax, and its value into the green columns of the Template tab.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Fill in a missing type from the source record. A number alone can't tell you phone from fax.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Show unassigned participant roles
Nurse, no actor → Unassigned participant role: Nurse
Get the template →
Add the patient response to the status
booked + tentative → booked; patient response=tentative
Get the template →
Flag a decline on a booked appointment
booked + declined → Review: booked but participant declined
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →