How to copy a pattern in a column

[Frankieboy]

Hi

I am sure this is straight forward but can't seem to work this out. In one column I might have 4 lines:

SL-001
SL-001
SL-002
SL-002

How do I copy the pattern down so that e.g. if there were 40 days I would end up with SL-040 (and 80 entries)?

Thanks

 

[Joe4]

Welcome to the Board!

On your sheet, what row are you placing your first entry (SL-001) in?

 

[Frankieboy]

Hi Joe4

Thanks! The SL-001 will always start at the second row.

 

[Frankieboy]

Sorry so B2.

 

[Joe4]

Place this formula in cell B2 and copy down as far as you need:

="SL-" & TEXT(INT(ROW()/2),"000")

 

[Frankieboy]

Hi Joe

That was a great help. Thanks very much.

Thanks.

 

[Joe4]

You are welcome.