Hi,

Is it possible and if so, how would I seperate text in a column to new columns using spaces, for example I have a field 'Contact Name' with names in the following format:
Mr John Barnes
Mr Kenny Daglish

I want to seperate these names into separte columns i.e.
Salutation First Name Last Name
Mr John Barnes
Mr Kenny Daglish

Any help would be great, thanks!

Data -> Text to Columns (Make sure there are blank columns behind the inital column)
then in the Wizard choose
Delimited
Next page choose other and in the small box put a space,
then finish

HTH

Dave

I take it your a liverpool fan then?

Text-to-Column works fine. You can also use formulas:

Assume your cell is A2,

Title, put in cell B2:

=LEFT(A2,FIND(" ",A2)-1)

First Name, put in C2:

=IF(ISERR(MID(A2,FIND(" ",A2)+1,IF(ISERR(FIND(" ",A2,FIND(" ",A2)+1)),FIND(" ",A2),FIND(" ",A2,FIND(" ",A2)+1))-FIND(" ",A2)-1)),"",MID(A2,FIND(" ",A2)+1,IF(ISERR(FIND(" ",A2,FIND(" ",A2)+1)),FIND(" ",A2),FIND(" ",A2,FIND(" ",A2)+1))-FIND(" ",A2)-1))

Last Name, put in D2:

=RIGHT(A2,LEN(A2)-FIND("*",SUBSTITUTE(A2," ","*",LEN(A2)-
LEN(SUBSTITUTE(A2," ","")))))

Thanks all...such a long way round to do this...thought Excel would have this function in a similar format!!! and yes I am a Liverpool fan

I suppose it could of been newcastle or celtic as well,
If you want to you could write a function yourself to do this using VBA