| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula with text and number in cell
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test whether formula in cell is an expression or a number/text | Excel Worksheet Functions | |||
| How do I attach a number to a cell with text to use in a formula? | Excel Discussion (Misc queries) | |||
| Excel Formula, text & number in cell | Excel Discussion (Misc queries) | |||
| number and text in cell for formula | Excel Worksheet Functions | |||
| conditional formatting - problem with text cell value from formula | Excel Worksheet Functions | |||
Threaded Mode
