Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Including a Cell value into a Chart title with the Text? | Charts and Charting in Excel | |||
Using If to combine answers including text and numbers | Excel Worksheet Functions | |||
Novice user trying to use variables including text and numbers | Excel Worksheet Functions | |||
formula for pulling only numbers but not text from another cell | Excel Worksheet Functions | |||
extract number and use in formula from text & numbers in cell | Excel Worksheet Functions |