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.
S

Hi,

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.