Finding AlphaNumeric

[chandrashekar]

Hello,

Can you please help me in getting excel formula.

Regards,
Chandrashekar B

 

[BigBeachBananas]

How about this?

=IF(ISNUMBER(A2),"Numeric","AlphaNumeric")

 

[chandrashekar]

Hello,

It is working

Regards,
Chandrashekar B

 

[bebo021999]

Note that "ABC" (with no number inside) would return "AlphaNumeric" also
Is it OK?

 

[chandrashekar]

Hello,

Is it anyother way to find out?

Regards,
Chandrashekar B

 

[chandrashekar]

Note that "ABC" (with no number inside) would return "AlphaNumeric" also
Is it OK?

Hello,

Nope. I just pasted sample data. It may be anything. I want to find exact number.

Regards,
Chandrashekar B