Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting Text strings in one cell | Excel Discussion (Misc queries) | |||
Splitting 1 cell into 2 based on underscore in text | Excel Worksheet Functions | |||
splitting text from one cell | Excel Discussion (Misc queries) | |||
splitting text in a cell.. | Excel Discussion (Misc queries) | |||
Splitting Up Text in One Cell To Many | Excel Worksheet Functions |