Join semicolon choices with commas

Turn Email; Phone; Text message; into Email, Phone, Text message.

What you'll make

In Excel: Email; Phone; Text message; becomes Email, Phone, Text message.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The choices, split by semicolons."Email; Phone; Text message;"
2TEXTSPLIT( … ,";",,TRUE)Splits at semicolons and drops empty pieces."Email" " Phone" …
3TRIM( … )Removes the spaces around each choice."Email" "Phone" …
4TEXTJOIN(", ",TRUE, … )Joins the choices with commas."Email, Phone, Text message"

Each bracket wraps the one before it, so Excel works from the inside out. Choices stay in their order, repeats too.

=TEXTJOIN(", ",TRUE,TRIM(TEXTSPLIT(A8,";",,TRUE)))

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 choices. Paste choice cells into the green column of the Template tab. The readable lists fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Use this only when no choice has a semicolon inside it. A choice listed twice stays twice.

Microsoft's help: TEXTJOIN function