View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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