PJ,

Assume your data is in cell A1.

Choose from one of these three.

In cell B1 type =ISTEXT(A1), or

=ISNUMBER(A1), or

=OR(ISTEXT(A1),ISNUMBER(A1))


" wrote:


Hi

How do I validate whether a data entered in a cell in alphanumeric? I
dont find any functions available...Is there someway to do using the
existing functions??

Thanks
Pras