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, " ")