VBA to split out hyphen strings into comma delimited

[decadence]

Hi, Is it possible to split a hyphen string into comma delimited.

Example:

From This
[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]A1-10
[/TD]
[/TR]
[TR]
[TD]J1D1_4-J1D1_7
[/TD]
[/TR]
[TR]
[TD]C2, C4-C8, C12
[/TD]
[/TR]
</tbody>[/TABLE]

To This
[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]A1, A2, A3, A4, A, A, A7, A8, A9, A10
[/TD]
[/TR]
[TR]
[TD]J1D1_4, J1D1_5, J1D1_6, J1D1_7
[/TD]
[/TR]
[TR]
[TD]C2, C4, C5, C6, C7, C8, C12
[/TD]
[/TR]
</tbody>[/TABLE]

 

[decadence]

Hi Peter, Thank you for the info, this code will definitely help as I believe there will be prefixes like this from time to time. Thanks again

 

[Peter_SSs]

You're welcome.