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:


[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD][/TD]
[TD]References
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A3, A7, A10-A15, A17, A19
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B12-18, B20
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C01-C09
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D01,D04,D08,D013-016
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


To This:


[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD][/TD]
[TD]References
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A3,A7,A10,A11,A12,A13,A14,A15,A17,A19
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B12,B13,B14,B15,B16,B17,B18,B20
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C1,C2,C3,C4,C5,C6,C7,C8,C9
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D1,D4,D8,D13,D14,D15,D16
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.