Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Copy first and last name

Posted by Paul on August 01, 2001 11:45 AM

In cell A1 I have "first & last name" example Joe Doe, I need a formula to copy the first name in cell A1 to cell B1 and the last name to cell C1, Thanks for your help.

Re: Copy first and last name

Posted by Corey on August 01, 2001 3:37 PM

Try this:

Highlight cell A1
Data
Text to Column..
Delimited
Select "Space" as delimiter
Select B1 as your destination
Finish

Corey

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.