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
|