Harlan -

There's a long series of posts in an earlier thread "Extracting a numbers
from a text string" where I finally got the answer for the OP, but I'd bet
you could promulgate a far simpler solution. Can you take a look?


"Harlan Grove" wrote:

Duke Carey wrote...
This array formula appears to work

=SUM(--SUBSTITUTE(B11:B3,"*",""))

commit it with Ctrl-Shift-Enter
....

Or use SUMPRODUCT, e.g.,

=SUMPRODUCT(--SUBSTITUTE(B1:B3,"*",""))

and not have to bother with array entry.