Ok, I have been trying so many different ways but all have come up short
on one aspect or another. I'd say this is due to my lack of
understanding of the formulas...

Let me explain EXACTLY what I need:

My table looks like this

NAME.......................ADDRESS................ .....PHONE
etc...
RT & J Smith.............30 Blake Street
JK Nguyen................45 Bronson Road
LE Rogers.................66 Brokern Avenue
JM Le.......................2/17 Regan Road
KR & J Rethers...........44 Telesales Point


The NAME field takes the format 'RT & J Smith' where RT is the first
and middle name initials of one person (husband), the J being the first
initial of the second person (wife) and Smith being the shared surname.

The NAME field stretches for like 50,000 records and I need to filter
all NAMES that contain asian type last names, such as Le or Nguyen.

I have tried using an Advanced Filter, but it is pulling the records
that are like 'LE Rogers', so i've ATTEMPTED to include EXACT so it is
case sensitive and pulls out 'JM Le' and not 'LE Rogers'.

ALL I want to do is identify or copy all the asian name records, and
i'm sure that all I need is an Advanced Filter with Case
Sensitivity...

By the way, I really appreciate all the help you guys have provided,
even though it's causing my head to bleed.

Cheers! Michael Gallagher


--
M.Gallagher
------------------------------------------------------------------------
M.Gallagher's Profile: http://www.excelforum.com/member.php...o&userid=31299
View this thread: http://www.excelforum.com/showthread...hreadid=509708