LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 125
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Breaking up Column da Excel Discussion (Misc queries) 6 March 17th 09 10:24 PM
2 columns have same data:Sort column E, but column A changes as we MUTTMIND Excel Worksheet Functions 1 February 16th 09 11:27 AM
breaking apart columns in pivot table vbasean Excel Discussion (Misc queries) 9 September 26th 08 09:06 PM
Breaking a long column to print on one sheet Pathwalker Excel Discussion (Misc queries) 1 August 30th 08 08:15 PM
Breaking up a string into separate columns Loz Excel Worksheet Functions 5 November 22nd 05 03:08 AM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"