Hello,
I'm a total noob when it comes to this so please be kind.
I need to clear the contents (not delete rows) in a column A. The contents contain numbers from 1 to 99, as well as something like 5ú _ or 4_ as well as ===== , ------- or occasional G.
These are generated by an old DOS program, and need to be cleared because they confuse the person reading the report.
In other words. Only the 3-digit numbers need to remain, everything else must go. Of course, this can be done by hand, but this report has to be run every day, and the sample below is just 1/20th of the whole thing...
Any help would be appreciated.
Sample:
<colgroup><col></colgroup><tbody>
</tbody>
I'm a total noob when it comes to this so please be kind.
I need to clear the contents (not delete rows) in a column A. The contents contain numbers from 1 to 99, as well as something like 5ú _ or 4_ as well as ===== , ------- or occasional G.
These are generated by an old DOS program, and need to be cleared because they confuse the person reading the report.
In other words. Only the 3-digit numbers need to remain, everything else must go. Of course, this can be done by hand, but this report has to be run every day, and the sample below is just 1/20th of the whole thing...
Any help would be appreciated.
Sample:
A DRI |
D |
=== |
111 |
4ú |
--- |
116 |
5ú |
G |
5ú |
G |
65 |
--- |
122 |
5ú |
65 |
--- |
129 |
4_ |
--- |
135 |
5ú |
65 |
--- |
223 |
2ú |
--- |
242 |
5ú |
G |
5ú |
G |
65 |
--- |
285 |
5ú |
65 |
--- |
509 |
65 |
--- |
524 |
65 |
--- |
556 |
DR |
D |
=== |
2ú |
--- |
558 |
5ú |
G |
5ú |
G |
3ú |
--- |
--- |
DR |
D |
=== |
691 |
5ú |
G |
=== |
(c) |
<colgroup><col></colgroup><tbody>
</tbody>