Thanks Jacob
For some reason that wouldn't work for me
--
Martin
©¿©¬

On Mon, 18 May 2009 09:47:20 -0700, Jacob Skaria
wrote:

1. Using formulas

With the name McAllister Mr & Mrs E. in A1 try the below formulas in B1 and
C1. If that does work copy the formula down to the number of rows where you
have the names in A1.

2. Text to Columns

Select the data range. From menu DataTExt to Columns will display the
first few samples in teh data preview area.Next will take you to step 2. By
default tab will be ticked. Take off that and check only Space. and Next
This will put a line breaker in between the spaces. NextFinish. this will
split the data between spaces. Maintain Column A as such For B,C,D and E
might have information which needs to be combined. Use a formula in Col F
such as
In cell F1
=B1&" "&C1&" "&D1&" "&E1
will combine the initials and titles with a space delimiter...Now copy the
formula to all rows.. Once done copy paste special values to the next
column or to the same column........