First name, Last name in seperate columns

Giganews Newsgroups
Subject: First name, Last name in seperate columns
Posted by:  Capt_Trips (Capt_Trips.278giy_1146662100.737@excelforum-nospam.com)
Date: Wed, 3 May 2006

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?action=getinfo&userid=34080
View this thread:http://www.excelforum.com/showthread.php?threadid=538429

Replies