Searching the first name only

K

Kelly Lim

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
 
N

Norman Jones

Hi Kelly,

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

Norman Jones

Hi Kelly,
To find cells only containing Kelly, select the 'Find entire cells only'
option.
Click to expand...

Should have read:

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

Kelly Lim

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

Norman Jones

Hi Kelly,
Do you mean by tick" Match Entire Cells Content"??
Click to expand...

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.....
Click to expand...

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

Kelly Lim

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

Norman Jones

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!
 
Top