Easy way to split a column?

[Margaret]

I receive long lists of names from clients in Excel docs.
I now copy the column into Word, convert table to text,
convert back to table, copy those columns back into Excel.

Is there any way to do the procedure in Excel?

 

[J.E. McGimpsey]

Take a look at Data/Text to Columns.. in XL Help.

Also, perhaps:

http://cpearson.com/excel/firstlast.htm

 

[Margaret]

Thanks. I'll give it a try.

-----Original Message-----
Take a look at Data/Text to Columns.. in XL Help.

Also, perhaps:

http://cpearson.com/excel/firstlast.htm


.