Formulas not adding properly

[Richard Gendron]

Hi there
I have a cell that contains 1.1.1, I would a formulas that would increase it
by 0.0.1
So I would have

A1 = 1.1.1
A2 = 1.1.2
A3 = 1.1.3
etc.

when I enter 1.1.1 into A1 and use in A2
=TEXT(1+SUBSTITUTE(A1,".",""),"0\.0\.0")
at A10 instead of getting 1.1.10 I get 1.2.0


Can anyone help me ?
Tks, Rg

 

[Eleni Gioka]

Try this in A2

=LEFT(E1;4)&VALUE(RIGHT(E1;LEN(E1)-FIND("*";SUBSTITUTE
(E1;".";"*";LEN(E1)-LEN(SUBSTITUTE(E1;".";"")))))+1)

Hope this can be helpfull

E.G.

 

[JE McGimpsey]

One way:

=LEFT(A1,4)&MID(A1,5,15)+1

 

[Richard Gendron]

tks, that worked just fine

greatly appreciated.
rg