View Single Post
  #7   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Kelly,

Are you saying that you want to find any cells where *Kelly* is the first or
only word?

If so, use the search criterion:

Kelly*

and select the Match Entire cell option.

Forgive me for not understanding you sooner!

---
Regards,
Norman



"Kelly Lim" wrote in message
...
yes...i get what you mean by any cells containing "kelly" would appear.
....but i wanted the first name containing "kelly" to be search only.....
so is there a way?
Thanks again....