Forum Discussion
Column numbers with text
I want to fill column with next+1 cmd A1 K101 A2 K102 A3 K103 etc Formular A4 A3+1 A5 A4+1 A6 A5+1 etc answer should be A1 - A6 K101 - K106 A1+1 Function does not handle Text in the next ...
Btw, assuming A1 contains K101 then if you just select cell A1 and then click and hold the fill handle (bottom right corner of the cell) and drag it down, the number will be automatically incremented and you don't need any formula for that.