View Single Post
  #13   Report Post  
BizMark BizMark is offline
Member
 
Location: London
Posts: 78
Default

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