# Thread: Running Numbers Formula Thanks: 0 Likes:  2 Post #5309214 (1)Post #5310923 (1)

1. ## Running Numbers Formula

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

ID NAME CITY
(????) <--Here i want the formula that change the only NUMBERS not TEXT automatically.

3. ## Re: Running Numbers Formula

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

4. ## Re: Running Numbers Formula

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

such as this in A4:

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

Code:
`=LEFT(A3,3)&TEXT(1+RIGHT(A3,LEN(A3)-FIND("-",A3)),"00")`
Or you need to provide more examples re what you want.

5. ## Re: Running Numbers Formula

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

Thanks

6. ## Re: Running Numbers Formula

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.

7. ## Re: Running Numbers Formula

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")

8. ## Re: Running Numbers Formula

Originally Posted by Shafique
ID NAME CITY
(????) <--Here In ID Column i want the formula that change the only NUMBERS (XX-03) not TEXT.
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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•