Try this

=TRIM(SUBSTITUTE(J2,CHAR(160),""))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"aehan" wrote in message
...
On a column of imported text there are unwanted spaces to the left of the
text. I tried to get rid of them by inserting a column and writing a TRIM
function but the spaces remained - I've never seen that happen before.
Does
anyone have an idea why that should happen? I'm tearing my hair out. Any
ideas would be gratefully received. Thanks.