Forum Discussion
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
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
HTHHi,
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
Als je de cel naar beneden sleept dan opent er automatisch in de onderste cel een snelmenu voor doorvoeren. hier kun je de keuze maken welke doorvoer actie je wilt hebben.
