Utilizing the Excel TextJoin Function
Jump to navigation
Jump to search
- 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