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 genera...
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