Help with Substitute on Multiple variable

[tbruce]

Hi,

I'm trying to write a formula that will replace all the 3's with 4, all the 2's with 3, and all the 1's with 2, but need to do it in this order so it does the 3s first, then the 2s, then the 1s, that way it doesn't apply it twice to the number. The digit is in the first position from the left (e.g. 13029344, 23029344,33029344). Is there a way to do this with a formula? Any help would be appreciated.

Here is what I have for the first change which works, but can't figure out how to get the second and third variables changed with the same formula =SUBSTITUTE(B2,"3","4",1)

 

[tbruce]

Ok both of these appear to work - still validating. One this I need to do is also pull in the "0" value if present. So if the value in the cell is ZERO, go ahead and pull that in as ZERO. Any help for this last piece would be much appreciated

 

[tbruce]

Actually the second example pulls in the ZEROs so thank you everyone it looks like both work for the first value only.

 

[Peter_SSs]

One this I need to do is also pull in the "0" value if present.

Does that mean the original values are text?
If so, and the results are to be text, omit the double negation at the start of my formula.

20 09 09.xlsm
	A	B
1	30139	40139
2	20139	30139
3	10139	20139
4	30139	40139
5	30139	40139
6	55555	55555
7	02659	02659
8	0	0
Substitute

Cell Formulas
Range	Formula
B1:B8	B1	=REPLACE(A1,1,1,LEFT(A1,1)+OR(--LEFT(A1,1)={1,2,3}))