How do I select numbers for a formula from a cell including text?

[Ed]

I am using an Array Sum formula to total the quantities of orders from a
separate worksheet. The column in that worksheet that inculdes the part
number I want to select also includes some text. How do I select the number
I want from cells that include other information? I am using Excel 2007.

 

[Ron Rosenfeld]

I am using an Array Sum formula to total the quantities of orders from a
separate worksheet. The column in that worksheet that inculdes the part
number I want to select also includes some text. How do I select the number
I want from cells that include other information? I am using Excel 2007.

Please be more specific with examples of actual inputs and desired outputs. The
format of your data is important.

It's pretty easy, with a formula, to return the first set of consecutive
digits, or all the digits in a particular string.
--ron