use autofill on next cell in row using formula of the cell above

Copper Contributor

I am applying this formula in the first cell in the row 'A2' : ="SB-"&TEXT(ROWS(A$2:A2),"0000").

It should export this : SB-001.

In the next cell (in the same column in the next row) it will generate: SB-002

how to fill out the next cell ( in the same column in the next row) automatically, without using the fill handler to pull it down.

1 Reply

@kishta 

If you are on Excel 365 you may use something like

="SB-"&TEXT(SEQUENCE(100),"0000")

If not, put your formula in A2, enter into name box A2:A100 (or so), range will be selected, Ctrl+D