Home

Excel autofill combination of letters and numbers

Robert Ertsey
Occasional Visitor

How do I autofill combination of letters and numbers so that the numbers increment by 1. 

Example: TMT111, TMT112, TMT113 etc...

 

Thanks

6 Replies

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

 

increment.jpg

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

 

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. 

Hi Kim,

Thanks for your reply.

The icon that comes up when I drag the crosshairs down is the Quick Analysis tool.


@Lorenzo Kim wrote:

fill.png


How do I open up the icon that you show in your screenshot?

(You've probably gathered my computer skills are limited!)

Thanks,

Cliff

 

 

 

 

point to the left lower corner of the box, click the icon then select fill...

HTH

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies