Forum Discussion
use autofill on next cell in row using formula of the cell above
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
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
