trim spaces

Hi all.
Is there a way to trim spaces (beginning and ending spaces) with a ragic formula?
sometimes beginning or ending spaces in the resulting field may be more than one.
thanks in advance.


We do have TRIM(), it will trim all the spaces in beginning and ending, if there’s more than one space between two letters, keeps only the first one.