Excel Trim Function

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 17:53, 5 December 2017 by Tracy.Kimble (talk | contribs)
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

File: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