=SUBSTITUTE(A1,"A","A0")

copy down as far as needed


"Norm Gregoire" wrote:

I need the following number to look as follows:
Is: A1 D01-3
Want: A01 D01-3

I need to add a zero after the A to 3000 entries without changing the rest.
Can it be done?
Thanks
Norm