separate columns (three letter code)
in [General]
|
Prev: reduce excel file size
Next: Carriage return
From: mariekek5 on 16 Mar 2010 08:52 Great, this works perfectly. Is it also possible to get the rest in another column? Like text minus RIGHT(A1,3)...? "Jacob Skaria" wrote: > Use RIGHT() > > =RIGHT(A1,3) > > -- > Jacob > > > "mariekek5" wrote: > > > Thanks Jacob for your help. > > > > But actually, that will not work... I simplified my example, in real life it > > is: > > > > [Mw. dog PKO] > > [Mr. horse KLI] > > > > So I really need a formula, to separate the three letters on the right....I > > know there is a formula, but I forgot it... > > > > Hope you can help me out. > > > > Thanks in advance > > > > "Jacob Skaria" wrote: > > > > > --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 comma and hit Next. > > > > > > Hit Finish > > > > > > -- > > > Jacob > > > > > > > > > "mariekek5" wrote: > > > > > > > Hi, does someone know how to separate text from one column into two columns? > > > > > > > > I have columns like > > > > [dog, KKL] > > > > [horse, PPN] > > > > > > > > Everytime, three capitals in the end (which is a code). > > > > > > > > Is it possible to separate that, and put it in another column? > > > > > > > > Thanks in advance.
From: Jacob Skaria on 16 Mar 2010 08:56 Yes; try =LEFT(A1,LEN(A1)-3) -- Jacob "mariekek5" wrote: > Great, this works perfectly. > > Is it also possible to get the rest in another column? Like text minus > RIGHT(A1,3)...? > > > > "Jacob Skaria" wrote: > > > Use RIGHT() > > > > =RIGHT(A1,3) > > > > -- > > Jacob > > > > > > "mariekek5" wrote: > > > > > Thanks Jacob for your help. > > > > > > But actually, that will not work... I simplified my example, in real life it > > > is: > > > > > > [Mw. dog PKO] > > > [Mr. horse KLI] > > > > > > So I really need a formula, to separate the three letters on the right....I > > > know there is a formula, but I forgot it... > > > > > > Hope you can help me out. > > > > > > Thanks in advance > > > > > > "Jacob Skaria" wrote: > > > > > > > --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 comma and hit Next. > > > > > > > > Hit Finish > > > > > > > > -- > > > > Jacob > > > > > > > > > > > > "mariekek5" wrote: > > > > > > > > > Hi, does someone know how to separate text from one column into two columns? > > > > > > > > > > I have columns like > > > > > [dog, KKL] > > > > > [horse, PPN] > > > > > > > > > > Everytime, three capitals in the end (which is a code). > > > > > > > > > > Is it possible to separate that, and put it in another column? > > > > > > > > > > Thanks in advance.
From: mariekek5 on 16 Mar 2010 09:21
Great, works perfectly! Thank you! "Jacob Skaria" wrote: > Yes; try > > =LEFT(A1,LEN(A1)-3) > > -- > Jacob > > > "mariekek5" wrote: > > > Great, this works perfectly. > > > > Is it also possible to get the rest in another column? Like text minus > > RIGHT(A1,3)...? > > > > > > > > "Jacob Skaria" wrote: > > > > > Use RIGHT() > > > > > > =RIGHT(A1,3) > > > > > > -- > > > Jacob > > > > > > > > > "mariekek5" wrote: > > > > > > > Thanks Jacob for your help. > > > > > > > > But actually, that will not work... I simplified my example, in real life it > > > > is: > > > > > > > > [Mw. dog PKO] > > > > [Mr. horse KLI] > > > > > > > > So I really need a formula, to separate the three letters on the right....I > > > > know there is a formula, but I forgot it... > > > > > > > > Hope you can help me out. > > > > > > > > Thanks in advance > > > > > > > > "Jacob Skaria" wrote: > > > > > > > > > --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 comma and hit Next. > > > > > > > > > > Hit Finish > > > > > > > > > > -- > > > > > Jacob > > > > > > > > > > > > > > > "mariekek5" wrote: > > > > > > > > > > > Hi, does someone know how to separate text from one column into two columns? > > > > > > > > > > > > I have columns like > > > > > > [dog, KKL] > > > > > > [horse, PPN] > > > > > > > > > > > > Everytime, three capitals in the end (which is a code). > > > > > > > > > > > > Is it possible to separate that, and put it in another column? > > > > > > > > > > > > Thanks in advance. |