Is the first character a number or letter
Try something like this:
for a value in A1
B1: =ISNUMBER(--LEFT(A1,1))
That formula returns TRUE if the 1st char is a number, otherwise FALSE
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"bactfarmer" wrote:
I need a formula that tells you if the first character in a string is
a number or a letter.
Thanks
Very Cunfused
|