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