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

In Excel: phone + 201-555-0123 becomes phone: 201-555-0123.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8=""Checks whether the contact value is empty.FALSE
2IF(A8="", … )Flags a value that has no contact type.Has a type
3A8&": "&B8Writes the type, a colon and the value."phone: 201-555-0123"
4IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own contacts. Paste each contact type, such as phone or fax, and its value into the green columns of the Template tab.
  3. 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