Fill in consecutive ID numbers

**bhogz** · 10-08-2012, 08:46 AM

Any short way or formula?

Excel.png

My hands are painful by copy and paste a thousand lines of those.

Thanks for the help.

**jeffreybrown** · 10-08-2012, 08:51 AM

Do all of the id numbers start with DZ?

**bhogz** · 10-08-2012, 09:00 AM

No.

"DZ" is for Dozer

There are a lot of them,

"TH" is for = "Truck Heavy"

"TL" is for Tower Lights

SL, DP, LV, LW, etc..

**jeffreybrown** · 10-08-2012, 09:07 AM

Sounds like there are many variations, but if you move the one id into what I'm guessing could be column A, once that's done you can follow the instructions on this site to fill in the blanks. http://www.contextures.com/xlDataEntry02.html

Could this work for you?

**bhogz** · 10-10-2012, 03:37 AM

yeah it worked.

Thanks for the help mate.

**jeffreybrown** · 10-10-2012, 07:37 AM

Your'e welcome. Glad it worked out for you and thanks for the feedback

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save