In my spreadsheet I have a column called S+ No. How to auto increment this for each row, like:


In short, how to make it dynamic?

  • Have a look at this answer: stackoverflow.com/a/14286825/1536038 – Jacob Jan Tuinstra Feb 14 '13 at 12:04
  • I will work on a little Google Apps Script to do it automatically. – Jacob Jan Tuinstra Feb 14 '13 at 22:01
  • Good question. I'm not sure how to concatenate the letter with the number. All I know how to do is increment the number. If cell A1 = 1 then I set A2 to =A1+1. Then when I want to increment I click and drag down the bottom right side of the cell. Hopefully that helps you get toward your goal. – user39497 May 4 '13 at 5:17

One way would be to provide the first two items, then mark both and drag at the lower right corner for as many rows as you like:

Dragging lower right corner

And the result is:

enter image description here




meets your requirement. This will concatenate S with the row number the formula is in. You may wish to use an offset, so for example if you wish to start with S1 but in row 8 adjust to:

  • 2
    That's only valid if you do not remove or insert rows... – Jacob Jan Tuinstra May 20 '14 at 10:20
  • Hold your horses pnuts, I did provide a solution on Stack Overflow (see first comment). Should I've posted the same answer here? – Jacob Jan Tuinstra May 20 '14 at 11:09

Follow this link, you will get the exact answer:


  • 1
    Please include the actual solution in your answer, not by just linking to another page. If that page should go away some day, your answer will have little value. – Vidar S. Ramdal Aug 4 '14 at 10:23
  • also it is only giving numbers, not in combination with a character, isn't it? – StampedeXV Sep 4 '14 at 13:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.