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

This Form cannot be submitted until the missing fields (labelled below in red) have been filled in
Let me know what you think:
Please note that all fields followed by an asterisk must be filled in.
First Name*
E-Mail Address*
Feedback*
Please enter the word that you see below.