Insert character to multiple cells

[LeahBea]

I am trying to find a function that will insert a character mid text t
multiple cells. I need to make this "3AAA3" into this "3AAA03". I hav
tried the replace function and it does not seem to be working. Pleas
help!!

 

[Ron Rosenfeld]

I am trying to find a function that will insert a character mid text to
multiple cells. I need to make this "3AAA3" into this "3AAA03". I have
tried the replace function and it does not seem to be working. Please
help!!!

You don't give much information as to the possible variety of data with which you will be dealing, but with
3AAA3 in A1, =REPLACE(A1,LEN(A1),0,"0") will result in 3AAA03

 

[Spencer101]

I am trying to find a function that will insert a character mid text t
multiple cells. I need to make this "3AAA3" into this "3AAA03". I hav
tried the replace function and it does not seem to be working. Pleas
help!!!

Are all of the values you need to alter 3AAA3 and all should end u
3AAA03