simple question about excel

  • Thread starter Thread starter Μανολης Î’
  • Start date Start date
Î

Μανολης Β

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!
 
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
 
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!
 
--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
 
Data>Text to columns>Delimited>Check space as delimiter!
Regards,
Stefi

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