If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
simple question about excel
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 |
#3
|
|||
|
|||
simple question about excel
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 |
#4
|
|||
|
|||
simple question about excel
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 |
#5
|
|||
|
|||
simple question about excel
--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 |
#6
|
|||
|
|||
simple question about excel
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 |
Thread Tools | |
Display Modes | |
|
|