Excel Trim Function

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 17:35, 5 December 2017 by Tracy.Kimble (talk | contribs) (Created page with "*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...")
(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
  • If you wish to utilize the newly trimmed text be sure to Copy and Paste the VALUES (not the Function) into a new Column