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 Feb 14 '13 at 12:04
  • I will work on a little Google Apps Script to do it automatically. 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... 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? May 20 '14 at 11:09

Follow this link, you will get the exact answer:


  1. On your computer, open a spreadsheet in Google Sheets.
  2. In a column or row, enter text, numbers, or dates in at least two cells next to each other.
  3. Highlight the cells. You’ll see a small blue box in the lower right corner.
  4. Drag the blue box any number of cells down or across.
  • If the cells form a series of dates or numbers, the series will continue across the selected cells.
  • If the cells don’t form a series of dates or numbers, the list of values will repeat across the selected cells.
  • 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. 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.