Skip to content
Get lifelong access to all courses and certifications with Full Access.
Get lifelong access to all courses and certifications with Full Access.
What is TRIM Function in Excel

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 :


Excel Specialization Course

Example TRIM function, step by step:

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

  1. Select a range (A2:C21)
  2. 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!

Free Excel Tutorial
Previous article How to make an Icon Bar
Next article What is W3.JS

Leave a comment

* Required fields