"Gary" skrev i en meddelelse
...
all i wanna do is. if A3 has an alpha numeric value(E344) then the cell
should return X. if A3 has text then it should return Y



Hi Gary

Maybe this one:

=IF(ISNUMBER(A3)+(A3=""),"",IF(MIN(LEN(SUBSTITUTE( A3,{0,1,2,3,4,5,6,7,8,9},"")))<LEN(A3),"X","Y"))


--
Best regards
Leo Heuser

Followup to newsgroup only please.