Create a phone-and-fax block

Write Phone: and Fax: on two lines, leaving out a fax that is blank.

What you'll make

In Excel: 2015550123 + 2015550142 becomes Phone: 2015550123¶Fax: 2015550142.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1IF(A8="",…,"Phone: "&A8)Writes Phone: and the phone, if there is one."Phone: 2015550123"
2IF(B8="",…,"Fax: "&B8)Writes Fax: and the fax, if there is one."Fax: 2015550142"
3TEXTJOIN( … )Puts them on two lines and skips empty ones."Phone: …¶Fax: …"

¶ marks a line break. CHAR(10) and TRUE inside TEXTJOIN mean: a line break between, skip empty parts. The numbers here are made-up.

=TEXTJOIN(CHAR(10),TRUE,IF(A8="","","Phone: "&A8),IF(B8="","","Fax: "&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 numbers. Paste phones and faxes into the green columns of the Template tab. Leave a cell empty when there isn't one.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Turn on Wrap Text for the result cells wherever you paste them, or the two lines show as one.

Microsoft's help: TEXTJOIN function