Excel Trim Function

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
  • Create a new Column to place the trimmed values
  • Click on the Formulas tab, select the Insert Function button and search for 'Trim'
  • Click on the cell containing the text you want to trim and Click OK

Trim Function.JPG

  • If you wish to utilize the newly trimmed text be sure to Copy and Paste the VALUES (not the Function) into a new Column


Back to Application Troubleshooting