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
