top of page

Microsoft Excel TEXTJOIN() Function


TEXTJOIN() FUNCTION DEFINITION

=TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …)

BENEFITS

  • The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

Download the exercise file used in the video to follow along: ExcelTextJoinFunction-01.XLSX

26 views0 comments

Recent Posts

See All

Check out the video below on how to create Dynamic, Cascading Drop-Down Menus in a Microsoft Excel list. This method of creating Dynamic Drop-Down Menus uses the built-in Data Validation list tool, Na

bottom of page