Join first name in A, last name in B, and email in C with commas

公式

=TEXTJOIN(", ", TRUE, A2, B2, C2)

说明

TEXTJOIN inserts a delimiter between values. TRUE skips empty cells so you do not get extra commas.

步骤

  1. The first argument is the delimiter.
  2. TRUE ignores blanks.
  3. List cells or a range to join.

变体

Join a whole row range

Useful for exporting a CSV-like line from a record.

=TEXTJOIN(", ", TRUE, A2:F2)

Excel 2016 without TEXTJOIN

Simple ampersand join. Blanks still produce extra commas.

=A2&", "&B2&", "&C2

Unique list as a sentence

Spill-friendly summary of distinct names.

=TEXTJOIN(", ", TRUE, UNIQUE(FILTER(A2:A100, A2:A100<>"")))