If A3=alpha numeric,"X", if A3=text,"Y", Blank
Gary wrote:
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
As far as Excel is concerned, E344 is text.
If your alpha numerics are always the same format (i.e the second
character is a number), you can try:
=IF(ISNUMBER(MID(A3,2,1)*1),"X","Y")
Regards
Steve
|