Hi all, kindly advise me so that to create a VBA code which should run through col. “E” and clear the specific word “Account:” but no other number or description. Therefore, that the code should run from “E2”. Below I present the original data and the expected result.
Thanking you in advance
Original data
E | |
1 | Account |
2 | Account: 2020018 |
3 | Account: 2020018 |
<tbody>
</tbody>
Expected result
E | |
1 | Account |
2 | 2020018 |
3 | 2020018 |
<tbody>
</tbody>