Difference between revisions of "Excel Trim Function"
Jump to navigation
Jump to search
Tracy.Kimble (talk | contribs) |
|||
Line 4: | Line 4: | ||
[[File:Trim Function.JPG]] | [[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 | *If you wish to utilize the newly trimmed text be sure to Copy and Paste the VALUES (not the Function) into a new Column | ||
+ | |||
+ | |||
+ | ==Links== | ||
+ | Back to [[Application Troubleshooting]] |
Latest revision as of 15:29, 30 April 2018
- 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
Links
Back to Application Troubleshooting