View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
headly
 
Posts: n/a
Default 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.