Hi,

Have a look at
Data|text to columns

Use the space as a delimeter

Mike

"Nick C" wrote:

I have a list of names in one column, all of which are different lengths,
which I want seperating into different columns e.g.

Smith John Mr Mr John Smith
Johnson Pauline Miss Miss Pauline Johnson

Any ideas?

Regards,

Nick