Utilizing the Excel TextJoin Function

• Create a new Column to place the new TextJoin values
• Click on the Formulas tab, select the Insert Function button and search for 'TEXTJOIN'

• Utilize the appropriate Delimiter
• If creating a 'Pipe Delimited' list use the '|' value
• Click on the arrow at the end of the 'Text1' field
• Click on the cells containing the text you want to join and Click OK
• If you wish to utilize the newly joined text be sure to Copy and Paste the VALUES (not the Function) into a new Column