simple question about excel

[Μανολης Β]

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

 

[Ms-Exl-Learner]

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!

 

[Mike H]

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

 

[Ms-Exl-Learner]

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!

 

[Jacob Skaria]

--Select the range/column needs to be changed. From menu Data>Text 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

 

[Stefi]

Data>Text to columns>Delimited>Check space as delimiter!
Regards,
Stefi

„Μανολης Β†ezt írta: