Running Numbers Formula

[Shafique]

hello.
Hope You will be Fine.
My Question is that I Create a Table That Has Column as below


ID NAME CITY
AD-01 ABC UVW
AD-02 EFG XYZ
(????) <--Here i want the formula that change the only NUMBERS not TEXT automatically.
e.g. AD-03

 

[footoo]

https://www.mrexcel.com/forum/excel-questions/1103396-formula-have-sequence-numbers.html

 

[Shafique]

ID NAME CITY
AD-01 ABC UVW
AD-02 EFG XYZ
(????) <--Here In ID Column i want the formula that change the only NUMBERS (XX-03) not TEXT.
e.g. AD-03
This Suggested Solution(https://www.mrexcel.com/forum/excel-...e-numbers.html) is doesn't match or work on my request

 

[kweaver]

Are you trying to increment the AD-nn ID in the next row?

such as this in A4:

="AD-"&TEXT(1+RIGHT(A3,LEN(A3)-FIND("-",A3)),"00")

or

=LEFT(A3,3)&TEXT(1+RIGHT(A3,LEN(A3)-FIND("-",A3)),"00")

Or you need to provide more examples re what you want.

 

[Shafique]

i am very very Very Thanks full to you.
it work as i want.
you are my hero

Thanks

 

[jtakw]

Hi,

If I understand correctly, you don't need any formula for what you want.

With AD-01 in A2, Select A2, Left click and hold down on the cell Fill handle (little square in lower right corner of A2) and drag down Column, the Numbers with auto increment leaving the AD intact.

 

[Rick Rothstein]

Here is another (fairly simple) formula that can also be considered. Put this formula in the first cell (the one you want AD-01 to appear in) and copy it down as needed...

=TEXT(ROWS($1:1),"A\D-00")

 

[footoo]

ID NAME CITY
AD-01 ABC UVW
AD-02 EFG XYZ
(????) <--Here In ID Column i want the formula that change the only NUMBERS (XX-03) not TEXT.
e.g. AD-03
This Suggested Solution(https://www.mrexcel.com/forum/excel-...e-numbers.html) is doesn't match or work on my request

I think it does - Rick Rothstein has provided the same solution to that thread and this thread.