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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to merge a list of names into a Word document 1
HOW DO I EXTRACT NUMBERS FROM TEXT STRING 7
Extract from the beginning of a text string 3
Extract parts of a cell 6
Extract data in rows (with line breaks) to form a table 0
How do I extract a string from an IP address in Excel? 2
HELP: extract certain characters from text string 4
How to extract particular sentences containing a distinct word and put the sentence i 0

Top