I saw this in your other thread.

You may want to use:
=--trim(substitute(A2,char(160),""))
so the result of the formula is a number--not text.


wrote:
<<snipped
I did:

trim(substitute(A2,char(160),"")) and that worked perfectly to
eliminate the space at the front.

--

Dave Peterson