View Single Post
  #3   Report Post  
Anne Troy
 
Posts: n/a
Default

Hi, Sheila. You could try something like this:
=if(left(a1,6)="george",True,False)
************
Anne Troy
www.OfficeArticles.com

"sheila" wrote in message
...
If i have a range, lets name it "Names" and i want to find if the name
George is in that range, what formula should I use?

TIA
sheila