Clear data

[Panoos64]

Hi all, I would like to clear any symbols the word Undefined and once the number using vba. Please note that these data are in col. "A" and the rows are 3000+. The numbers are not the same but more than 40. e.g. 101003, 101004, 203001 e.t.c. The 1st schedule, shows the original data and the 2nd the expected result.

Many thanks in advance

<colgroup><col width="63"></colgroup><tbody>
[TD="width: 63"] 1st: ~101003-~101003**Undefined**


2nd:
101003
[/TD]

</tbody>

 

[Panoos64]

Hi gallen, It works perfect now!. Thank you so much for your time spent for me.

Hv a great lovely day