separate columns (three letter code)

[mariekek5]

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.

 

[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 comma and hit Next.

Hit Finish

 

[mariekek5]

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

--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

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.

 

[Mike H]

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.

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

--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

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.

 

[Jacob Skaria]

Use RIGHT()

=RIGHT(A1,3)

--
Jacob

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

--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

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.

 

[mariekek5]

Great, this works perfectly.

Is it also possible to get the rest in another column? Like text minus
RIGHT(A1,3)...?

Use RIGHT()

=RIGHT(A1,3)

--
Jacob

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

--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


:

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.

 

[Jacob Skaria]

Yes; try

=LEFT(A1,LEN(A1)-3)

--
Jacob

Great, this works perfectly.

Is it also possible to get the rest in another column? Like text minus
RIGHT(A1,3)...?

Use RIGHT()

=RIGHT(A1,3)

--
Jacob

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

:

--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


:

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.

 

[mariekek5]

Great, works perfectly!

Thank you!

Yes; try

=LEFT(A1,LEN(A1)-3)

--
Jacob

Great, this works perfectly.

Is it also possible to get the rest in another column? Like text minus
RIGHT(A1,3)...?

Use RIGHT()

=RIGHT(A1,3)

--
Jacob


:

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

:

--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


:

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.