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
Text to Column..
Select "Space" as delimiter
Select B1 as your destination