Hi all,
i 'm looking for solution to the following problem:
i have a string at B1 and C1 columns like this:
<tbody>
</tbody>
etc...
All i want is text extraction like:
D1 column E1 column
<tbody>
</tbody>How can i achieve this results?
TIA
i 'm looking for solution to the following problem:
i have a string at B1 and C1 columns like this:
bread | 1 item 330 calories |
apple sugar | 300g 1232 calories |
tost | 110g 250 calories |
<tbody>
</tbody>
etc...
All i want is text extraction like:
D1 column E1 column
1 item | 330 calories |
300 g | 1232 calories |
110g | 250 calories |
<tbody>
</tbody>
TIA