Difference between revisions of "Utilizing the Excel TextJoin Function"
Jump to navigation
Jump to search
Tracy.Kimble (talk | contribs) (Created page with "*Create a new Column to place the new TextJoin values *Click on the Formulas tab, select the Insert Function button and search for 'TEXTJOIN' File:TextJoin_Function.JPG *U...") |
(No difference)
|
Latest revision as of 18:09, 5 December 2017
- 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