Recent Posts

Archive

Tags

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

FOLLOW

  • Facebook

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb