Wild Card

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please with a fourmula for this problem
A B
George Aguilar Male

I would like the word "True" to be displayed if coulmn (A) begins with the letter "A throug G" and false if it begins with any other letter.

Thanks a lot
 
The "Code" formula turns a character into a number. Upper-
and lower-case letter carry different codes. The
following formula should work:

=IF(AND(CODE(UPPER(LEFT(<cell ref>,1)))>=65,CODE(UPPER(LEFT
(<cell ref>,1)))<=71),TRUE,FALSE)

If you need other laters later on, change the 65 and 71 to
the relevant upper case codes.

Rich

-----Original Message-----
Can someone please with a fourmula for this problem
A B
George Aguilar Male

I would like the word "True" to be displayed if coulmn
Click to expand...
(A) begins with the letter "A throug G" and false if it
begins with any other letter.
 
Back
Top