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

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.

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

On Tue, 31 Mar 2009 05:27:01 -0700, Ed wrote:

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