Forum Discussion

Robert Ertsey's avatar
Robert Ertsey
Copper Contributor
Sep 12, 2018

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

excel
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Sep 12, 2018

    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

     

    • CliffP's avatar
      CliffP
      Copper Contributor
      Dec 28, 2018

      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

       

Resources