DataText to ColumnsSpace delimited and Finish?

From your description, it is hard to figure out out exactly what you need.

Are the space-separated names in one cell?

What means "single column list" if they are already in one column?

Maybe a small example of your data would help.


Gord Dibben MS Excel MVP

On Sat, 24 Jun 2006 11:28:14 -0500, EyeGorePS
wrote:


I have a document with a list of names. All names are separated by a
space. How do i convert to a single column list in excel?