How do I extract part of a text string

B

Brennan

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?
 
D

Dave F

Use the text to columns tool--Data--Text to columns and select SPACE as your
delimeter.

Note: any data to the right of the column the names are in will be deleted
when you split the data into columns, so make sure you insert plenty of
columns befiore doing this.

Dave
 
Top