Help Extracting Numbers formula
Ok....sample...
If a given spreadsheet has...
3 days [in cell A1]
400 per day [in cell A2]
then in cell A3, I'd like to multiply 3 and 400.
Mind you, the cell has mixed text and numbers.
Some idiot submitted a huge spreadsheet without separating units from number
of units!!
--
Kwokman
"T. Valko" wrote:
Need more detail.
--
Biff
Microsoft Excel MVP
"Kwokman3" wrote in message
...
Help!!
Is there a way for excel to identify cells with number in them, then
extract
the numerical data from the cell and use it in another formula?
--
Kwokman
|