On a similar line to LEFT and RIGHT, TRIM can be used to remove unnecessary spaces from the beginning and end of text. If you’re working with data that has been produced automatically, e.g. by a database, this could be a common annoyance!

All you have to do it use this Function and “ example text ” becomes “example text”. The basic formula is:


If you’re working with a column of data you can enter the Excel formula once and then copy it down using the Autofill Function to cover the whole list.

I hope you've found this page useful; I’d appreciate it if you’d take the time to let me know how you rate it.

If you’re still struggling with the TRIM Function you might find it helpful to have another look at the Getting started with Excel formulas page.

Looking for more? Return to Excel Formulas or the Office Software homepage

If you've enjoyed this page, why not share it with your readers?

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.

Let me know what you think:

Please note that all fields followed by an asterisk must be filled in.

Please enter the word that you see below.


Get the Office Software Monthly Newsletter

Enter Your E-mail Address
Enter Your First Name (optional)

Don't worry — your e-mail address is totally secure.
I promise to use it only to send you Office Software Update.

What do you want to see more of?

Please note that all fields followed by an asterisk must be filled in.