Conditional formula with text and number in cell
=IF(B1="10 weak",10,"not 10 weak")
BTW............10 weak what's?
10 weak kittens?
10 weak cups of tea?
Gord Dibben MS Excel MVP
On Sat, 29 May 2010 11:47:01 -0700, RichM
wrote:
Hello,
Can a conditional formula be written to convert a cell with text and a
number to a cellw ith just a number?
I have a cell with the number 10 and the word "weak" in it. 10 weak
Can a conditional formula convert this to just the number "10"? I did
=If(b1= 10 weak,"10") but it does not work.
Thank you.
|