Excel Trim Function

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 15:29, 30 April 2018 by Crystal.Vervaecke (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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