MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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