atmospheric
Well-known Member
- Joined
- Jul 16, 2002
- Messages
- 565
I have an Order Number that takes the form ASC/2558.
How can I drag it down about 500 cells and have the last 4 digits increment by 1 in each cell?
e.g, in column B
B1 = ASC/2558
B2 = ASC/2559
B3 = ASC/2560
etc
Or perhaps a better solution for me would be that if there was an entry in A2, make B2 one greater than B1
Hope that makes sense,
Thanks in advance
How can I drag it down about 500 cells and have the last 4 digits increment by 1 in each cell?
e.g, in column B
B1 = ASC/2558
B2 = ASC/2559
B3 = ASC/2560
etc
Or perhaps a better solution for me would be that if there was an entry in A2, make B2 one greater than B1
Hope that makes sense,
Thanks in advance