separate columns (three letter code)
in [General]
|
Prev: reduce excel file size
Next: Carriage return
From: mariekek5 on 16 Mar 2010 08:15 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:20 --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 08:34 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: Mike H on 16 Mar 2010 08:37 Hi, maybe this =LEFT(RIGHT(A1,4),3) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "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:40
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. |