Separating identifications and dates in a cell

[Nadine67]

Hello and thanks in advance for any attention this post will receive.

I have a value in a cell that contains container id's and dates which i need to separate into separate cells. Column A is called 'Containers' and there are in excess of 1000 entries so separating manually is very laborious; a formula would be ideal - i have tried using LEN, MID, LEFT and RIGHT, with no success. I need to separate the id's (e.g. D5602) from the date. Some cells have two ID/ date combinations and others have 3 ID/date combinations. Some ID's have 4 characters and others have 5. Dates are always in brackets DD/MM/YY. Each ID/Date is separated by a comma. I do not wish to use 'Text to Columns as it is too manual a process.

	COL 'A'
1	CONTAINERS
2	D5602(07/06/15),D540(06/06/15),C9856(30/05/15)

<TBODY>
</TBODY>

 

[AlKey]

Enter this formula in B1 and pull to the right until you see blanks.

=TRIM(MID(SUBSTITUTE("("&SUBSTITUTE(SUBSTITUTE($A1,",",""),")","("),"(",REPT(" ",125)),125*COLUMNS($A:A),125))

Excel 2010
	A	B	C	D	E	F	G
1	D5602(07/06/15),D540(06/06/15),C9856(30/05/15)	D5602	07/06/15	D540	06/06/15	C9856	30/05/15
Sheet7

 

[Nadine67]

Gidday and thank you AlKey. Your formula is returning exactly what i need. Thank you again and have a great day!