---

TRIM Function

The TRIM function is premade in Excel and used to remove irregular text spacing and keep single spaces between words.

It is typed =TRIM

If you want to use the function on a single cell, write:

If you want to use the function on a range of cells, write:

---

---

Example TRIM Function

Use Trim to tidy up irregular spaces in the dataset within the range A2:C21.

---

How to Use TRIM Function

Step 1) Start the TRIM function

1. Select a cell E2
2. Type =TRIM
3. Double click the TRIM command

Step 2) Select a range of cells to be used in the TRIM function

4. Select a range (A2:C21)
5. Hit enter

---

---

The function returns a dataset formatted without irregular spaces:

Step 3) Use the 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!