separate columns (three letter code)
 

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.

separate columns (three letter code)
 

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

separate columns (three letter code)
 

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

separate columns (three letter code)
 

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

separate columns (three letter code)
 

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

separate columns (three letter code)
 

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

separate columns (three letter code)
 

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

separate columns (three letter code)
 

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