I have been forking on solving an problem extracting a specific portion of a text from a string.
Here is a few examples of the text format that is in column A:
<COLGROUP><COL style="WIDTH: 233pt; mso-width-source: userset; mso-width-alt: 11337" width=310><TBODY>
</TBODY>
Here is a few examples of the text format that is in column A:
Invoice: PST-53012-IN:CID:XYZ10010819: id Month (
<COLGROUP> <COL style="WIDTH: 233pt; mso-width-source: userset; mso-width-alt: 11337" width=310> <TBODY> </TBODY> |
<COLGROUP><COL style="WIDTH: 233pt; mso-width-source: userset; mso-width-alt: 11337" width=310><TBODY>
</TBODY>