Hi Kelly,

Do you mean by tick" Match Entire Cells Content"??

Yes. The exact wording differs depending upon the version of Excel being
used.

if yes.....it cannot search the data by the name "kelly" when i tick
it.....

Are you sure that the cells ONLY contain *Kelly* and not * Kelly" (space
Kelly) or *Kelly * (Kelly space)?

Have you unchecked the Match Case option?

In any event, If I enter some instances of *Kelly* and some of *Kelly Lim*,
searching with the Match Entire Cells Content (or its equivalent) selected,
only cells containing *Kelly* were found - as expected.

---
Regards,
Norman



"Kelly Lim" wrote in message
...
Do you mean by tick" Match Entire Cells Content"??
if yes.....it cannot search the data by the name "kelly" when i tick
it.....