Assume that you are having the €œGeorge Smith€� value in A1 cell.

A1 cell
George Smith

B1 cell
=TRIM(LEFT(A1,FIND(" ",A1)-1))

C1 cell
=TRIM(RIGHT(A1,FIND(" ",A1)-1))

Change the cell reference A1 to your desired cell, if required.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Μανολης Β" wrote:

I have an excel list with 300 names. Each name and surname are both written
to the same cell (eg. "George Smith"). However i want name and surname be in
2 different cells. Is there any function or command that i can aply and solve
my problem??
I think that this command can recognize the gap between the 2 words and then
divide the text into 2 cells insead of 1 or cut and paste a part of the text
to an other cell.

thanks a lot
Manolis