thanks, but still not working.

simply function like =sum() is returning 0...after applying trim/substitute

"Ron Rosenfeld" wrote:

On Wed, 15 Mar 2006 04:29:27 -0800, Claus Massmann
wrote:

i have copied data from a website and would like to apply certain formulas to
it, but the data has 2 blank spaces after the last digit and therefore
formulas are not working.

I've tried trim, clean and neither are working.

Can anyone help?
Thanks

There is most likely a no-break space in the string (CHAR(160)).

So try:

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

You may need to precede this with a double unary if this is numeric data, as
the formula returns text.

=--TRIM(SUBSTITUTE(A5,CHAR(160),""))
--ron