If your "Mister Blackwell RRT" is in A1:
To get the name: =LEFT(A1,LEN(A1)-4)
To get the three letter code: =RIGHT(A1,3)

These are, of course, formula so you must retain the original
Learn about Copy followed by Paste Special /Values to transform formula to
data.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"mariekek5" wrote in message
...
Hi, can someone help me with the following:

In 400 cells I have a name + a code with name + a code with three letters,
for example: Mister
Blackwell RRT. I would like 'Mister Blackwell' in one cell, and 'RRT' in
another cell. Is it possible to separate the three letter code from the
name?

Thanks a lot in advance.

Marieke