If I have a cell A1 with a name entered in the format 'Mr A B SURNAME',
how can I get it shortened to just the start and end in B1 so it will
just show 'Mr SURNAME'.

thanks


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=378932