Hi

Life is never easy is it?
What I would do, is first do a Search & Replace.
Ctrl+H Find Jr. (that is a space followed
by Jr.)
Replace _Jr. (underscore followed by
Jr.)
Replace All

Repeat for Sr.

Use my formula to do your split.
Then reverse the Find & Replace to change the underscore back to a
space.


--
Regards

Roger Govier


"jermsalerms"
wrote in message
...

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