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....
|