=sum() will ignore the text values in that range.

But it sounds like your "numbers" aren't numbers. They are text masquerading as
numbers.

David McRitchie has a macro that cleans up this kind of stuff:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()"

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ainsley wrote:

Ive tried those formulas which unfortunatly dont work.

My Trial Balance has some numbers and some spaces in it. The spaces
are causing problems as whatever formulas I use I get errors as I cant
add up numbers and spaces. The spaces are caused by my accounting
package displaying an abscence of a value as a space, as if you used
your space bar to clear out a cell.

How do I remove the "spaces" so there is nothing in the cell ?

Regards, Ainsley

--
Ainsley
------------------------------------------------------------------------
Ainsley's Profile: http://www.excelforum.com/member.php...o&userid=31960
View this thread: http://www.excelforum.com/showthread...hreadid=538042

--

Dave Peterson