Hi,
I have text in a single excel cell which looks like this:
* Apple: some general text. * Pear: more text. * Orange:some more text.
I need to extract the each instance of the strings between the characters * and :, and put them in separate, adjacent cells.
e.g.
<tbody>
</tbody>
Is there a way to do this with either excel formulas in each of the adjacent cells, or else via a macro?
Thanks in advance.
I have text in a single excel cell which looks like this:
* Apple: some general text. * Pear: more text. * Orange:some more text.
I need to extract the each instance of the strings between the characters * and :, and put them in separate, adjacent cells.
e.g.
A1 | B1 | C1 | D1 |
Above Text | Apple | Pear | Orange |
<tbody>
</tbody>
Is there a way to do this with either excel formulas in each of the adjacent cells, or else via a macro?
Thanks in advance.