Thanks for you help earlier (TWIMC)

If i have a list as follows:

SMITHMRD&MRSE
JONESMRF
ELLIOTMRM&MRSK
JOHNSMRS&MRSP

As you can see its's a surname 1st, then, ie its Mr S & Mrs K, is there
anyway this can be seperated so it looks like below?:

SMITH MRD&MRSE
JONES MRF
ELLIOT MRM&MRSK
JOHNS MRS&MRSP

Help much appricated!!!


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=512709