Are the fields separated by a common value, like a comma? For example:
Smith, Joe
Doe, John
If so, you can use the Data-Text to Columns feature. Choose "Delimited"
and on the next screen choose whatever value separates the first and last
name.
--
Regards,
DavidB
"drbonne" wrote:
Have downloaded data with first and last names lumped together in one cell.
Is there a way to have excel split the first and last name into two separate
cells?
|