VBA to replace the charachter on the right with another character.

[saved1ne]

I would like to be able to replace the ending character on the far right side with a replacement character. The column where I need the replacement are the same.

Example: in Column A is the following data
2
12
22
32
42
A02
A12
A32
Needs to be:
3
13
23
33
43
A03
A13
A33
If possible, when I click on the macro button I would like to be able tell tell the macro what I would like the last number to be changed to.

Thanks

[Mumps1]

Try:

Please Login or Register  to view this content.

[saved1ne]

Thanks so much, that worked perfectly!

[Mumps1]

You are very welcome.

[lazam]

God bless your efforts
thank you

[Mumps1]

Thank you for the kind words.