On Sat, 26 Feb 2005 15:49:03 -0800, "ivanj"
wrote:

I have a spread sheet which has a single column of names in the format of
Allen, Paul etc. Is there a way to write a macro using visual basic to create
two columns, one for first name (Paul) and one for last name (Allen)? Column
has about three thousand names in single column format.

Appreciate your thoughts and comments.

Thanks

If you have completely described your requirements, then you could record a
macro while executing the Data Text to columns wizard, using "comma" as the
delimiter.


--ron