Forum Discussion
Robert Ertsey
Sep 12, 2018Copper Contributor
Excel autofill combination of letters and numbers
How do I autofill combination of letters and numbers so that the numbers increment by 1.
Example: TMT111, TMT112, TMT113 etc...
Thanks
- Lorenzo KimBronze Contributor
I learned this from Mr. jtakw..
enter into the cell the string - then at the lower right of the cell (cell handle) - there is square marker - mouse point it then drag down to the desired range then release..you can do any string (alphanumeric text) with this.
as simple as that
HTH- CliffPCopper Contributor
Hi,
I noted the reply to your query and wonder if you can help me?
I input a string, say 1 2 3 4.
When I drag the handle down, the values all revert to 1 which keeps on repeating a column of 1.
Same with a date string. I enter 28/12/2018 and then 29/12/2018 etc,.
When I drag down, the dates all are 28/12/2018.
This was working great and has only just started going awry.
Have you any suggestions?
Thanks
- Lorenzo KimBronze Contributor