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

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

Hi,

The simplest way would be 'Text to columns'

So, select your data then

Data|Text to columns - Select delimited - Next - Check 'Space' and Finish

Mike



"Μανολης Β" 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

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

--Select the range/column needs to be changed. From menu DataText to Columns
will populate the 'Convert Text to Columns Wizard'
--By default the selection is 'Delimited'.Keep the selection and hit 'Next'.
--From the Step2 of the Wizard from the options select Space
--Hit Finish

If this post helps click Yes
---------------
Jacob Skaria


"Μανολης Β" 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

DataText to columnsDelimitedCheck space as delimiter!
Regards,
Stefi

€žÎœÎ±Î½Î¿Î»Î·Ï‚ Î’€� ezt Ã*rta:

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