decadence
Well-known Member
- Joined
- Oct 9, 2015
- Messages
- 525
- Office Version
- 365
- 2016
- 2013
- 2010
- 2007
- Platform
- Windows
Hi, Is it possible to split a hyphen string into comma delimited.
Example:
From This
<tbody>
</tbody>
To This
<tbody>
</tbody>
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>