TRIM

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:

=TRIM(CELL REFERENCE)

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



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)
Then

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.