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

L

lmcadams

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.
 
H

headly

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