Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My question is : How do I UNconcatenate the data below into its original form
of cell A1 & B1 -Data Form- Concatenate result: XZU422R-HKMRS3-2312 Cell: A1: XZU422R-HKMRS3 Cell: B1: 2312 =concatenate(A1,"-",B1) But how do I UNconcatenate it to its original form of cell A1 & B1? ie 1 cell become 2 cells and it is formula base. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
unconcatenate? | Excel Discussion (Misc queries) |