Hi all, I would like to remove symbols ~-* in col. "A" using VBA as my below extract. Sch. 1 shows the original data and sch. 2 is the expected result. Thanking you in advance
<colgroup><col style="mso-width-source:userset;mso-width-alt:10678;width:219pt" width="292"> </colgroup><tbody>
</tbody>
Schedule 2.
<tbody>
</tbody>
Schedule 1. ~101003-~101003 **Undefined** |
~101004-~101004 **Undefined** |
~101005-~101005 **Undefined** |
~10102-~10102 **Undefined** |
<colgroup><col style="mso-width-source:userset;mso-width-alt:10678;width:219pt" width="292"> </colgroup><tbody>
</tbody>
Schedule 2.
101003 101003 Undefined |
101004 101004 Undefined |
101005 101005 Undefined |
10102 10102 Undefined |
<tbody>
</tbody>