Ron,

Can I post files here? I can post the spread sheet that would show exactly
what I am attempting to do. I am using MS Office 2007 Pro.

Thanks

"Ron Rosenfeld" wrote:

On Fri, 22 Feb 2008 19:09:00 -0800, Wayne
wrote:

Okay Thanks to both of you, unfortunately I cant seem to get either option
to work. I am weak in this area of Excel. I get the function entered okay,
just keep getting reference errors. For Gords I get a #VALUE! Error if I
attempt to reference more than one cell. In my example I should have stated
that this is a time sheet therefore I need to sum up K1 to K9. For Rons in
the same case I get a Function not valid error.

In your original post you indicated the string was in "a" cell, implying one
cell. That is how my function is designed to work. It is NOT designed to work
over a multicell reference. But it will work not only on the example you gave,
but also on examples like 14.63CDE + 0.478ABC (again all in one cell).

If you have mixed-text and numbers in K1:K9, you should be able to enter my
function in an adjacent column in the form =EvalNums(K1) and fill down to K9;
then SUM that column.

Or you could provide more specific information about your data.

Also, I've not seen a "Function not Valid" error. Where do you see that? What
version of Excel?

In mine, when I select multiple cells, I get a #VALUE! error in the worksheet
cell with the formula.
--ron