Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Visual Basic Function works fine in Excell 2003 but not in Excel 2 | Excel Discussion (Misc queries) | |||
visual basic | Excel Worksheet Functions | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |