Is the first character a number or letter
try something like
=ISNUMBER(LEFT(A1,1)*1)
where A1 is the string you are evaluating. Multiplying the leftmost
character by 1 seems to be necessary to keep it from being considered
a text string that looks like a number.
Good luck.
Ken
Norfolk, Va
On Jan 30, 1:15 pm, "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
|