It's not pretty but it works (might be a start...?):

TRIMLEFT: =RIGHT(H4,LEN(H4)-MIN(IF((MID(H4,ROW(INDIRECT("1:"&LEN(H4))),1)<"
"),(ROW(INDIRECT("1:"&LEN(H4)))),""))+1)
TRIMRIGHT: =LEFT(H4,MAX(IF((MID(H4,ROW(INDIRECT("1:"&LEN(H4)) ),1)<"
"),(ROW(INDIRECT("1:"&LEN(H4)))),"")))

TRIMLEFT&RIGHT: Combine the two

Ola Sandstrom


Note:
Since it's an Array formula you have to end the formulas by holding down
Ctrl+Shift and then press Enter.
It will work if " " is Not found both at the beginning and at the end.
My idea was to find the Min position <" " (trimleft) and the
Max...(trimright)