If I type:
"1+A*2-B"
into a cell, I want to have a series of cells beneath that will hold each separate letter (or string, that would be helpful)
so in this case, i want:
<tbody>
</tbody>
Prefferably, it would also work for groups of letters, and also group them together:
<tbody>
</tbody>
Preferably no VBA as I want to convert the sheet into another code language.
"1+A*2-B"
into a cell, I want to have a series of cells beneath that will hold each separate letter (or string, that would be helpful)
so in this case, i want:
1+A*2-B |
A |
B |
<tbody>
</tbody>
Prefferably, it would also work for groups of letters, and also group them together:
100*fuel+2/tyres |
FUEL |
TYRES |
<tbody>
</tbody>
Preferably no VBA as I want to convert the sheet into another code language.