Thank you very much. That works very well. However now that I look at
my list a little closer I have some fields that have a middle name or
initial. Is there a way that we can make this formula break down into
3 columns for first middle and last??

Thanks


--
shane24
------------------------------------------------------------------------
shane24's Profile: http://www.excelforum.com/member.php...fo&userid=4770
View this thread: http://www.excelforum.com/showthread...hreadid=490090