Your formula works great but I found that some of my contacts have Jr,
Sr., etc.
With your formula what I get for the last name is just Jr.
What would make it reflect say "Smith Jr." for example
Thanks
--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
View this thread:
http://www.excelforum.com/showthread...hreadid=498521