Get started
What is TRIM Function in Excel
đź‘‹ Introduction
The TRIM function is a premade function in Excel used to remove irregular spacing in text, and keeping single spaces between words.
It is typed =TRIM
Note:Â Irregular spacing is unnecessary spacing within the dataset that can occur before, after or between text or numbers within a cell.
Example TRIM Function
Use Trim to tidy up irregular spaces in the dataset within the range A2:C21.
Note: To define the range, separate the range values with a colon symbol :
Example TRIM function, step by step:
- Select a cellÂ
E2 - TypeÂ
=TRIM - Double click the TRIM command
- Select a range (
A2:C21) - Hit enter
The function returns a dataset formatted without irregular spaces:
Example TRIM Function with spacing between text
Use =TRIM function by following the steps in the example above to format the text:
The text looks much better now!
Leave a comment