Visual Basic and Excell
 

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

Visual Basic and Excell
 

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

Visual Basic and Excell
 

Ron What do you mean by "Data Text to columns wizard"? I don't understand.

Thanks

"Ron Rosenfeld" wrote:

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

Visual Basic and Excell
 

On Sat, 26 Feb 2005 17:53:01 -0800, "ivanj"
wrote:

Ron What do you mean by "Data Text to columns wizard"? I don't understand.

On the main menu bar in Excel (the bar at the top), one of the drop down menus
is entitled "Data". One of the items on that menu is named "Text to Columns".
When you click on that item, you will bring up the "Convert Text to Columns
Wizard" dialog box.


--ron

Visual Basic and Excell
 

Thanks Ron. I was just getting ready to post a note saying I found the way to
do the seperation. Data-text to Coumn-delimited. Works like a champ.

Thanks again

"Ron Rosenfeld" wrote:

On Sat, 26 Feb 2005 17:53:01 -0800, "ivanj"
wrote:

Ron What do you mean by "Data Text to columns wizard"? I don't understand.

On the main menu bar in Excel (the bar at the top), one of the drop down menus
is entitled "Data". One of the items on that menu is named "Text to Columns".
When you click on that item, you will bring up the "Convert Text to Columns
Wizard" dialog box.


--ron

Visual Basic and Excell
 

Thanks Ron. I was just going to post a reply to you. Clicking on Data--Text
to Columns-delimited works like a champ.

Thanks again

"Ron Rosenfeld" wrote:

On Sat, 26 Feb 2005 17:53:01 -0800, "ivanj"
wrote:

Ron What do you mean by "Data Text to columns wizard"? I don't understand.

On the main menu bar in Excel (the bar at the top), one of the drop down menus
is entitled "Data". One of the items on that menu is named "Text to Columns".
When you click on that item, you will bring up the "Convert Text to Columns
Wizard" dialog box.


--ron

Visual Basic and Excell
 

On Sat, 26 Feb 2005 19:05:03 -0800, "ivanj"
wrote:

Thanks Ron. I was just going to post a reply to you. Clicking on Data--Text
to Columns-delimited works like a champ.

Glad you solved your problem. Thank you for the feedback.


--ron