On Jan 31, 12:24 am, "Harlan Grove" wrote:
"Sunrays17" wrote...
i am looking forward to know is there any formula to know if a value
is alphanumeric too, as well as its a number or a letter...

...

Adapt some of the other formulas. Alternatively,

=COUNT(SEARCH(LEFT(s,1),"0123456789ABCDEFGHIJKLMNO PQRSTUVWXYZ"))

returns TRUE if the first char in s is alphanumeric, FALSE otherwise.
This is easily adapted to non-English languages with more/other
letters.

Thanks buddy...

we are close to the required result...

tke care...