helping creating working formula

[lukelim]

Sorry for naive question, but appreciate somebody could helping me. thanks

 

[lrobbo314]

This copied down, ="SKU-"&TEXT(ROW(),"0000")

Or, more like your example,

="SKU-"&TEXT(INT(RIGHT(A1,4))+1,"0000")

 

[lrobbo314]

Or even easier, Put SKU-0001 to SKU-0003 in cells A1:A3. Select A1:A3, go to the bottom right hand corner of cell A3 and hover until the cursor changes to crosshairs, then click and drag down as far as you need.

 

[Peter_SSs]

This copied down, ="SKU-"&TEXT(ROW(),"0000")

More robust would be
="SKU-"&TEXT(ROWS(A$1:A1),"0000") copied down

That way, if new rows are subsequently added above, the formulas will still start the sequence at 0001