View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brennan Brennan is offline
external usenet poster
 
Posts: 19
Default How do I extract part of a text string

I need to extract the first name from one cell and put it into another column.

Example:

John Smith John
Andrew Johnson Andrew
Michael White Michael

I'm sure its pretty easy, but I can't seem to figure it out. Can anyone help?