Home |
Search |
Today's Posts |
#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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |