Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
unconcatenate
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
unconcatenate
See one response to your multi-post in .worksheet.functions
(Pl do not multi-post) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- " wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
unconcatenate
Look at DataText To Columns
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) " wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unconcatenate? | Excel Discussion (Misc queries) |