Thread: Find rows that contain capital letter?
View Single Post
  #4   Report Post  
DustyT DustyT is offline
Junior Member
  
Posts: 3
Default
Quote:
Originally Posted by Claus Busch View Post

the formula will give you a TRUE or FALSE for the first letter of the
email address:
=AND(CODE(LEFT(B1,1))64,CODE(LEFT(B1,1))<91)
Hi Claus,

That's fantastic - thanks.

Dusty.
Reply With QuoteReply With Quote