wow steve..i tried MID but dint do *1.

it worked...thanks a ton

"Scoops" wrote in message
oups.com...

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