Drag Text/Number and add 1

[atmospheric]

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

 

[2rrs]

Does this do what you want?

In B4 enter =IF(A4<>"","ASC/"&ROW()+2558,"")

 

[Aladin Akyurek]

Does this do what you want?

In B4 enter =IF(A4<>"","ASC/"&ROW()+2558,"")

What happens when some rows are inserted before the data?

 

[atmospheric]

Thanks people, all 3 work perfectly. You were correct in your assumption Yogi, if nothing in A, leave B blank.

Thanks again for all your help folks.