Tag: TEXTJOIN

Excel TutorialTutorial

Combine Values & Delimiters Using Excel’s TEXTJOIN Function

How to Use Excel's TEXTJOIN Function =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Excel’s TEXTJOIN function provides a quick way of combining values in different cells, like for example first, middle and surnames as shown below.  This has always been possible in Excel but TEXTJOIN provides a better solution if you need to include…

Read More