One way which might suffice, assuming data is representative ..

Assuming C1 houses the concat formula:
=concatenate(A1,"-",B1)

In D1:
=LEFT(C1,SEARCH("-",C1,SEARCH("-",C1)+1)-1)
D1 returns: XZU422R-HKMRS3

In E1:
=RIGHT(C1,LEN(C1)-SEARCH("-",C1,SEARCH("-",C1)+1))
E1 returns the text number: 2312

And if you want the text number in E1 returned as a real number
just "+0" to it, ie put instead in E1:
=RIGHT(C1,LEN(C1)-SEARCH("-",C1,SEARCH("-",C1)+1))+0
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
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.