IF they contain text, then the whole cell is text. You would need a formula
that strips the number out, then sum the numbers.
I believe you would have to describe clearly the content of the cell and how
the data is arranged it get a good answer - also is this a programming
question or are you looking for a formula solution?
--
Regards,
Tom Ogilvy
DHINES said:
I AM TRYING TO SUM SEVERAL CELLS THAT CONTAIN A NUMBER AND TEXT. IS THERE
