separate letters from cell
If its always 3 letters at the rightmost bit in the string
Your data in A1 down
In B1: =RIGHT(A1,3)
In C1: =TRIM(SUBSTITUTE(A1,B1,""))
Copy B1:C1 down. Col B returns the 3 letters, col C returns the rest of the
string minus the 3 letters. joy? wave it, hit the YES below
--
Max
Singapore
---
"mariekek5" wrote:
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?
|