There may be more than two items in the cell. The data will always be
word/space/number/space/word/space/number and the same for any more items
added.

"Ron Rosenfeld" wrote:

On Mon, 15 Jan 2007 05:13:02 -0800, enyaw
wrote:

I have a cell that people can input both text and values in. Example:
Absent 15 Breaks 20. I need to be able to add the values in a seperate
cell. How would I do this?

What is the variability in the data?

In other words, will the data always be
word/space/number/space/word/space/number?

Will the numbers always be integers?

Will there always be two numbers?

etc.


--ron