View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Capt_Trips
 
Posts: n/a
Default First name, Last name in seperate columns


Hello,
I have a very large spreadsheet with customer information...Company,
Name, Address, City, etc etc...The problem is that Name is first name
and last name in one column...I would like to have first name in one
column and last name in another. Is there any way to do this without
copying and pasting 25,000 names?
Any help would save me days of work
Thanks
John


--
Capt_Trips
------------------------------------------------------------------------
Capt_Trips's Profile: http://www.excelforum.com/member.php...o&userid=34080
View this thread: http://www.excelforum.com/showthread...hreadid=538429