software

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: www.excelforum.com/member.php...oamp;userid=34080
View this thread: www.excelforum.com/showthread...hreadid=538429Insert a column at B.
Select column A.
Datagt;Text To Columns and use a delimiter of space.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Capt_Tripsquot; gt; wrote
in message ...
gt;
gt; Hello,
gt; I have a very large spreadsheet with customer information...Company,
gt; Name, Address, City, etc etc...The problem is that Name is first name
gt; and last name in one column...I would like to have first name in one
gt; column and last name in another. Is there any way to do this without
gt; copying and pasting 25,000 names?
gt; Any help would save me days of work
gt; Thanks
gt; John
gt;
gt;
gt; --
gt; Capt_Trips
gt; ------------------------------------------------------------------------
gt; Capt_Trips's Profile:
www.excelforum.com/member.php...oamp;userid=34080
gt; View this thread: www.excelforum.com/showthread...hreadid=538429
gt;
Have you tried?
Datagt;text to columns

--
Don Guillett
SalesAid Software

quot;Capt_Tripsquot; gt; wrote
in message ...
gt;
gt; Hello,
gt; I have a very large spreadsheet with customer information...Company,
gt; Name, Address, City, etc etc...The problem is that Name is first name
gt; and last name in one column...I would like to have first name in one
gt; column and last name in another. Is there any way to do this without
gt; copying and pasting 25,000 names?
gt; Any help would save me days of work
gt; Thanks
gt; John
gt;
gt;
gt; --
gt; Capt_Trips
gt; ------------------------------------------------------------------------
gt; Capt_Trips's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34080
gt; View this thread: www.excelforum.com/showthread...hreadid=538429
gt;