Hi,

to get the name

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

To get the 3 letter code

=RIGHT(A1,3)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mariekek5" wrote:

Hi, can someone help me with the following:

In 400 cells I have a 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