Combine Values & Delimiters Using Excel’s TEXTJOIN Function
How to Use Excel’s TEXTJOIN Function =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) 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 a delimiter between… Read More »Combine Values & Delimiters Using Excel’s TEXTJOIN Function