Hello, I'm using the below formula which works well in most instances:
=IF(E1="","",IF(OR(E1="null",ISNUMBER(E1)),"number",IF(ISERROR(FIND("/",E1)),"text","number")))
Where it does not work is where the cell contains letters first and then some numbers (e.g. ABCD 1234), where it comes up incorrectly as "text" instead of "number".
I would like to add an argument to this formula that says... if E1 contains any number, anywhere in the cell, then "number", otherwise "text".
Can I get some help on this please?
=IF(E1="","",IF(OR(E1="null",ISNUMBER(E1)),"number",IF(ISERROR(FIND("/",E1)),"text","number")))
Where it does not work is where the cell contains letters first and then some numbers (e.g. ABCD 1234), where it comes up incorrectly as "text" instead of "number".
I would like to add an argument to this formula that says... if E1 contains any number, anywhere in the cell, then "number", otherwise "text".
Can I get some help on this please?