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