I have a column which contains data like this: F540044000
I need help writing a macro which will remove the zero in the 4th place, put 38 in the beginning, and remove the last two zeroes.
So it will look like this: 38F540440
The sheet changes, so I will need to be able to run this over and over again.
Thank you.
I need help writing a macro which will remove the zero in the 4th place, put 38 in the beginning, and remove the last two zeroes.
So it will look like this: 38F540440
The sheet changes, so I will need to be able to run this over and over again.
Thank you.