Thread: Unconcatenate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] Qull666@hotmail.com is offline
external usenet poster
 
Posts: 114
Default 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.