Solved Copy paste half of cell in Excel cell into two

August 2, 2012 at 01:14:39
Specs: Macintosh
Hi I want to separate cell b which has the fist and last name to

cell a only first name
cell b only last name

at the moment

it is in cell b both first and last name in cell B eg. anna taylor

See More: Copy paste half of cell in Excel cell into two

Report •

August 2, 2012 at 02:03:45
✔ Best Answer
Since your data is already in Column B, you must extract the last name into another cell.

Have you tried the Data...Text To Columns feature? Use the "space" as the delimiter.

If you want to use a formula, you can try these:

For simple 2 string names such as "Anna Taylor", try this:

First Name:

=LEFT(B1,FIND(" ",B1)-1)

Last Name:

=MID(B1,FIND(" ",B1)+1,LEN(B1))

If you have names with 3 strings such as Anna Nicole Taylor, you can do it 2 steps by extracting the names twice, e.g.

First Name formula: Anna
Last Name Formula: Nicole Smith


First Name formula :Nicole
Last Name formula: Smith

There are also some longer formulas that will extract the middle and last names directly. You can Google around and find various versions.

You might also want to try this site:

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question