|
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 |
First name, Last name in seperate columns
Insert a column at B.
Select column A. DataText To Columns and use a delimiter of space. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "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 |
| All times are GMT +1. The time now is 07:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com