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.