Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Do you mean by tick" Match Entire Cells Content"??
if yes.....it cannot search the data by the name "kelly" when i tick it..... |
#5
|
|||
|
|||
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..... |
#6
|
|||
|
|||
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.... |
#7
|
|||
|
|||
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.... |
#8
|
|||
|
|||
That's very great....this is what i want...
Thank you so much Norman.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching Columns | Excel Discussion (Misc queries) | |||
Excel quits responding searching for files not in my documents | Excel Discussion (Misc queries) | |||
Find (Ctrl +F) not searching all open sheets | Excel Worksheet Functions | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Searching for Substrings Within Strings | Excel Discussion (Misc queries) |