MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)