Searching the first name only
 

Hi there....
Im having a column of names.....and i usually use "Find / Replace"....
but then i would like to find out if there's other method which i can
use.....because E.g. when i wanted to search the 1st name containing
"Kelly"...it would search everything name which contain "kelly" in it.....i
only want the first name........
i tried the match case, or using *kelly* in the Find/Replace...but it
still doesnt work......

Pls help me asap....thanks a lot

Hi Kelly,

To find cells only containing Kelly, select the 'Find entire cells only'
option.

---
Regards,
Norman



"Kelly Lim" wrote in message
...
Hi there....
Im having a column of names.....and i usually use "Find / Replace"....
but then i would like to find out if there's other method which i can
use.....because E.g. when i wanted to search the 1st name containing
"Kelly"...it would search everything name which contain "kelly" in
it.....i
only want the first name........
i tried the match case, or using *kelly* in the Find/Replace...but it
still doesnt work......

Pls help me asap....thanks a lot

Hi Kelly,

To find cells only containing Kelly, select the 'Find entire cells only'
option.

Should have read:

To find cells only containing Kelly, select the 'Find entire cells only'
option in the Find or Replace dialogs.

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Kelly,


---
Regards,
Norman



"Kelly Lim" wrote in message
...
Hi there....
Im having a column of names.....and i usually use "Find / Replace"....
but then i would like to find out if there's other method which i can
use.....because E.g. when i wanted to search the 1st name containing
"Kelly"...it would search everything name which contain "kelly" in
it.....i
only want the first name........
i tried the match case, or using *kelly* in the Find/Replace...but it
still doesnt work......

Pls help me asap....thanks a lot

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

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.....

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....

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....

That's very great....this is what i want...

Thank you so much Norman....