Analyzing a string for alpha characters.

J

jeff

Hi,

the total solution may be more than this, but
=IF(ISTEXT(B18),"T","") will tell you if there's
text in B18.

jeff
-----Original Message-----
This is a great place for advise.
Is there a formula for searching a text string to
Click to expand...
determine if it contains any alpha characters? I need to
convert a text string to a number if no alpha characters
exist (using Value), else, leave it alone.
 
Top