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

A1-10

J1D1_4-J1D1_7

C2, C4-C8, C12

<tbody>
</tbody>

To This

A1, A2, A3, A4, A, A, A7, A8, A9, A10

J1D1_4, J1D1_5, J1D1_6, J1D1_7

C2, C4, C5, C6, C7, C8, C12

<tbody>
</tbody>

 

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