Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking the data of column A into two columns First Name & Last name.
Hi,
I have a database of 5000 Names in Column A. e.g. A1:A5000, e.g. Murali Baggam Akash Maheshwari Diya Kathuriya Rajiv Kumar Taparia Sunita Kumari Iyar Rani I want to break the data of column A into two columns First Name & Last name with the help of a macro. Awaiting for the help from ur side. Thanks Akash |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking the data of column A into two columns First Name & Last name.
=Split(A:A, " ") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking the data of column A into two columns First Name & Last name.
Sorry I am not able to find the Split function in excel 2003.
More over i want a new column for every word after a space Suppose in Cell A1 i have a name like:Sunita Kumari Iyar Rani So I want Sunita in cell B1 So I want Kumari in cell C1 So I want Iyar in cell D1 So I want Rani in cell E1 This is the main Requirement. And I wanted to do the same with the help of macros. how this can be done. Thanks Akash On Jun 16, 3:40 pm, NOPIK wrote: =Split(A:A, " ") |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking the data of column A into two columns First Name & Lastname.
Insert a few columns to the right of column A (to hold those parsed values).
Then select your range data|text to columns delimited (by space) and finish up If you really need a macro, you can record one when you do it manually. Akash wrote: Sorry I am not able to find the Split function in excel 2003. More over i want a new column for every word after a space Suppose in Cell A1 i have a name like:Sunita Kumari Iyar Rani So I want Sunita in cell B1 So I want Kumari in cell C1 So I want Iyar in cell D1 So I want Rani in cell E1 This is the main Requirement. And I wanted to do the same with the help of macros. how this can be done. Thanks Akash On Jun 16, 3:40 pm, NOPIK wrote: =Split(A:A, " ") -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking the data of column A into two columns First Name & Last name.
On Jun 16, 4:54 pm, Dave Peterson wrote:
Insert a few columns to the right of column A (to hold those parsed values). Then select your range data|text to columns delimited (by space) and finish up If you really need a macro, you can record one when you do it manually. Akash wrote: Sorry I am not able to find the Split function in excel 2003. More over i want a new column for every word after a space Suppose in Cell A1 i have a name like:Sunita Kumari Iyar Rani So I want Sunita in cell B1 So I want Kumari in cell C1 So I want Iyar in cell D1 So I want Rani in cell E1 This is the main Requirement. And I wanted to do the same with the help of macros. how this can be done. Thanks Akash On Jun 16, 3:40 pm, NOPIK wrote: =Split(A:A, " ") -- Dave Peterson- Hide quoted text - - Show quoted text - thanks a tonn for helping me.... |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking the data of column A into two columns First Name & La
Hi,
NOPIK is playing with you! There is no such function is Excel, not even in 2007. Thanks, Shane Devenshire "NOPIK" wrote: =Split(A:A, " ") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breaking up Column | Excel Discussion (Misc queries) | |||
2 columns have same data:Sort column E, but column A changes as we | Excel Worksheet Functions | |||
breaking apart columns in pivot table | Excel Discussion (Misc queries) | |||
Breaking a long column to print on one sheet | Excel Discussion (Misc queries) | |||
Breaking up a string into separate columns | Excel Worksheet Functions |