Alphanumerics

Posted by Chris D on January 09, 2002 1:55 PM

Hi all,

is there an easy way to recognise an alphanumeric ?

I can get Excel to recognise numbers and I can get excel to recognise text, but am having difficulty getting it to recognise an alphanumeric

(all my data is 4 characters : TNNN

text, number, number, number

B010
C228
F447
G772

etc etc)

=ISALPHANUMERIC(.....

would be good

*sigh*

thanks
Chris D

Posted by Mark W. on January 09, 2002 2:01 PM

=AND(ISERROR(LEFT(A1)+0),ISNUMBER(RIGHT(A1,3)+0)) (nt)