Removing Spaces at the Beginning and/or End of a Text String

I'm working with a table of names and sometimes when I import them I get a space before the name and sometimes a space after the name. Is there a function or some code I can run to check whether the first character and the last character in a cell is a space character, and if any, or both, occur have them removed (the space characters either before or after the name? Thanks!

Note: Sometimes the data I'm working with imports ' John Doe' and sometimes it imports 'John Doe '. Very rarely I get ' John Doe ', but it has happened. Thanks!

Originally Posted by popipipo

You can use the 'TRIM' function

That was easy! Thanks!

Originally Posted by FDibbins

assuming your data is in A1, use this, copied down...
=TRIM(A1)

Beautiful! Thanks!