Splitting text in one cell and combine in a new cell
 

I have a text value that looks like: "FRJ.P.RJ123456(0)". I want it to to
take only
the "RJ123456" piece and put it into another cell. I have tried to use the
Custom
feature in formatting the cell to look like "AAA.B.CCCCCCCC.DDD"
And then try to use TEXT(a1,"CCCCCCCC"). But the contents in the new cell is
always the whole text from Cell A1 and not just the piece I want.

Splitting text in one cell and combine in a new cell
 

Assuming all entries are in the same format:

=MID(A1,FIND(".",A1,FIND(".",A1)+1)+1,8)

Biff

"JimR" wrote in message
...
I have a text value that looks like: "FRJ.P.RJ123456(0)". I want it to to
take only
the "RJ123456" piece and put it into another cell. I have tried to use
the
Custom
feature in formatting the cell to look like "AAA.B.CCCCCCCC.DDD"
And then try to use TEXT(a1,"CCCCCCCC"). But the contents in the new cell
is
always the whole text from Cell A1 and not just the piece I want.