extracting text strings from a cell

[penfold]

Hi,

I have a column of names which can include a combination of title, firstname and surname.

Is it possible to extract text strings based on position of spaces e.g.:

1) extract text before 1st space
2) extract text after 1st space and before the 2nd space
3) extract text after the 2nd space and before 3rd space etc

Many thanks

[arthurbr]

Hi,
select your data and select the Data menu - Text to columns - Select " delimited" - Check "Space " Uncheck other options and finish the wizard.
Cheers