unconcatenate

[Guest]

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.

 

[Max]

See one response to your multi-post in .worksheet.functions
(Pl do not multi-post)

 

[Bob Phillips]

Look at Data>Text To Columns

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)