Have you tried?
Datatext to columns

--
Don Guillett
SalesAid Software

"Capt_Trips" wrote
in message ...

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