I need a similar effect to the one above, but my list contains names in
the form LASTNAME, FIRSTNAME MI. and I want to remove the middle
initials. Not all of them have a middle initial in them. Thanks!


--
JFALK
------------------------------------------------------------------------
JFALK's Profile: http://www.excelforum.com/member.php...o&userid=24728
View this thread: http://www.excelforum.com/showthread...hreadid=381827