Utilizing the Excel TextJoin Function

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
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'

TextJoin Function.JPG

  • 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