Format serie of numbers

N

Norm Gregoire

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
 
M

Mike

Assuming your first number is in A1 enter this in B1 and drag down

=LEFT(A1,1)&"0"&+MID(A1,2,7)
 
A

andy62

If it's the only "A" in the text you could just use the Replace function, and
replace "A" with "A0"
 
D

daddylonglegs

With a formula in another cell.....assuming your data in cell B2

=REPLACE(B2,2,0,0)
 
N

Norm Gregoire

Thanks to all,
I used the REPLACE function for this problem. Back in business!
 
Top