On Sat, 9 Sep 2006 07:41:02 -0700, Kris wrote:

I copied and pasted a spreadsheet to EXCEL 2003 and the cells have spaces in
front of the numbers preventing the addition function. How do I fix this?

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

CHAR(160) is a non-printing space frequently found in HTML documents.



--ron