[Nick C]

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

[Mike H]

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

[Gord Dibben]

If your data is consistent as your example.

You could use DataText to ColumnsSpace delimited then swap A and C columns.

Or you could download Chip Pearson's FirstLast workbook to see how he uses
formulas to adjust.

http://www.cpearson.com/excel/FirstLast.htm


Gord Dibben MS Excel MVP


On Wed, 11 Jun 2008 04:35:00 -0700, Nick C <Nick
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