| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
There's actually a very simple way.
Use the normal 'Find' function but, for example, if you're searching for entries that begin with 'U', then enter the following: Find what: U* (i.e. U followed by star/asterisk) Click: Options Tick: Match Entire Cell Contents That way, Excel will search ONLY for cells whose first letter is 'U' - it won't find any cell that has 'U' anywhere in it. Regards, BizMark Last edited by BizMark : August 12th 05 at 01:55 PM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Hybrid Mode
