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.