I have below data in column A, in this string suffixed with data like "(12345/A76D7YF)". I need numeric and alphanumeric character in two different columns. Please note that customer names before above section may also contain (, ) and /. Uniqueness of column A is that after the last open bracket "(", the required numeric and alphanumeric data comes which may help is building any logic/VBA code
<tbody>
</tbody>
<colgroup><col width="97"></colgroup><tbody> </tbody> | 8CZNISNS | 614726 | |
<colgroup><col width="97"></colgroup><tbody> </tbody> | 3BAX80ZJ | 306521476 | |
<colgroup><col width="97"></colgroup><tbody> </tbody> | MZ0QR1LJ | 3953084 | |
<colgroup><col width="97"></colgroup><tbody> </tbody> | A3RJ67K3K | 467578 | |
<colgroup><col width="97"></colgroup><tbody> </tbody> | 2GN4E1U8 | 5961944 |
<tbody>
</tbody>