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.