VBA split References by comma delimited

[decadence]

Hi, I am trying to expand references by comma delimited but not sure how. can someone help with this please

Example:

From This:

	References
	A3, A7, A10-A15, A17, A19
	B12-18, B20
	C01-C09
	D01,D04,D08,D013-016

<tbody>
</tbody>

To This:

	References
	A3,A7,A10,A11,A12,A13,A14,A15,A17,A19
	B12,B13,B14,B15,B16,B17,B18,B20
	C1,C2,C3,C4,C5,C6,C7,C8,C9
	D1,D4,D8,D13,D14,D15,D16

<tbody>
</tbody>

 

[Peter_SSs]

I'm wondering why this thread exists at all?
Apart from whether the results are separated by comma or comma-space, it is identical to the one you asked back in July for which the codes suggested back then (at least I have checked mine) still work with this data.