Quote:
Originally Posted by RichM
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.
|
can you post more examples?
Do you want to fetch only numeric data? or is the sentence too long "10 weak tigers........." etc?
All the best