extracting numbers
Hi!
Enter this formula in A2:
=IF(ISERROR(LEFT(A1)*1),"",LEFT(A1)*1)
Enter this formula in A3:
=IF(ISERROR(MID(A1,FIND(" ",A1)+1,1)*1),"",MID(A1,FIND(" ",A1)+1,1)*1)
Biff
"cj" wrote in message
...
i need a formula to extract numbers.
if cell a1 is "3cash 5stock", i want to extract the number "3" to cell a2
and extract the number "5" to cell a3. the number in cash stock can vary
between 1 to 8 and vice versa.
can some help
|