Text formula
Posted by Mo on March 08, 2001 1:58 PM
Hello, I'll start with an example, suppose cell (A1), I want cell (B1) to return (A1) if cell (A1) is a text, if cell (A1) is a number , I want a blank. So if cell (A1) displays "Hello", then (B1) should return "Hello", if (A1) displays 100, then (B1) displays blank.
I Know how to accomplish this task, but I need 2 different cells to achieve result. In one cell I Put
=ISTEXT(A1)
In another cell , I use an IF function to interpret the results.
Something like =IF(ISTEXT(A1,A1,"")). (THE FORMULA ON THE LEFT IS WRONG).
Thankyou for your help.
Posted by Mark W. on March 08, 2001 2:05 PM
=IF(ISTEXT(A1),A1,"")
...but, you could get by with...
=A1
...if you were interested in only governing
display and formatted B1 as ;;;@
Posted by Mo on March 09, 2001 12:13 PM
Thankyou very much Mark
