Need Help for the formulae or code

[Ajayk]

when we enter like this as input in excel: - TRANS: 1ZLFS5; LN: 75; ITM: 34914301

we need this as out put in separate column: -'1ZLFS5'||75||'34914301',
is there any possible way to get output like above, can anyone please help me.

 

[Snakehips]

@Ajayk. Welcome to MrExcel.

Is this of any value?

Picking%20Teams (version 1).xlsb
	A	B
1
2	TRANS: 1ZLFS5; LN: 75; ITM: 34914301	'1ZLFS5'||75||'34914301'
3
Sheet5

Cell Formulas
Range	Formula
B2	B2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"TRANS: ","'"),"; LN: ","'||"),"; ITM: ","||'")&"'"