Hi,
I have cell which contains C45-C90, I want it to split into multiple rows and fill in the form C45, C46,C47...C90
For example:
<tbody>
</tbody>
Expected Result
<tbody>
</tbody>
<tbody>
</tbody>
Hope it's clear, please help me if there is any way I would be able to accomplish this.
I have cell which contains C45-C90, I want it to split into multiple rows and fill in the form C45, C46,C47...C90
For example:
colA | ColB |
C45-C50 | 0.6 |
C99-C101 | 0.5 |
<tbody>
</tbody>
Expected Result
Col A | Col B | Col C |
C45 | C45-C50 | 0.6 |
C46 | 0.6 | |
C47 | 0.6 | |
C48 | 0.6 | |
C49 | 0.6 | |
C50 | 0.6 | |
C99 | C99-C101 | 0.5 |
<tbody>
</tbody>
C100 | 0.5 | |
C101 | 0.5 |
<tbody>
</tbody>
Hope it's clear, please help me if there is any way I would be able to accomplish this.
Last edited: