How do I take only one word out of a cell and move to another cell
 

I am trying to do a mailing list and the first name and second name is in the
same cell. I want them in two different cells.

How do I take only one word out of a cell and move to another cell
 

Insert a few blank columns to the right to hold results.
Data menu Text to Columns Command, use space seperator

"lmcadams" wrote:

I am trying to do a mailing list and the first name and second name is in the
same cell. I want them in two different cells.