Dragging a cell to increment the last letter or digit

[craigwojo]

Hi everyone,
I forgot how I was able to drag a cell and get the last letter or digit to incrementally follow the cells above each other.

If I input E24A in a cell (let's say G4) and drag the corner of the cell to make

E24A
E24B
E24C and so on...

Thank you all so much,
Craig

 

[SunnyAlv]

I can't drag it down to your liking either, but I have a formula for you that might help u

If cell G1 contains "E24A", then in G2 enter this formula and copy it as needed, and you can change it according to your wishes

=CONCAT("E24",CHAR(CODE(RIGHT(G1,1))+1))

 

[craigwojo]

I can't drag it down to your liking either, but I have a formula for you that might help u

If cell G1 contains "E24A", then in G2 enter this formula and copy it as needed, and you can change it according to your wishes

=CONCAT("E24",CHAR(CODE(RIGHT(G1,1))+1))

How could I have the option of having, after "E24Z" the numbers would go to "E24AA, E24AB, etc.

Thank you and God bless,
Craig

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Scott Huish]

="E24"&SUBSTITUTE(ADDRESS(1,COLUMNS($A$1:A1),4),1,"")

 

[Peter_SSs]

="E24"&SUBSTITUTE(ADDRESS(1,COLUMNS($A$1:A1),4),1,"")

Scott, I think the OP is dragging down, not across ..

incrementally follow the cells above each other.

.. so

23 12 16.xlsm
	G
1
2
3
4	E24A
5	E24B
6	E24C
7	E24D
8	E24E
9	E24F
10	E24G
11	E24H
12	E24I
13	E24J
14	E24K
15	E24L
16	E24M
17	E24N
18	E24O
19	E24P
20	E24Q
21	E24R
22	E24S
23	E24T
24	E24U
25	E24V
26	E24W
27	E24X
28	E24Y
29	E24Z
30	E24AA
31	E24AB
32	E24AC
33	E24AD
701	E24ZV
702	E24ZW
703	E24ZX
704	E24ZY
705	E24ZZ
706	E24AAA
707	E24AAB
708	E24AAC
709	E24AAD
Increment

Cell Formulas
Range	Formula
G4:G33,G701:G709	G4	="E24"&SUBSTITUTE(ADDRESS(1,ROWS(G$4:G4),4),1,"")

 

[craigwojo]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

The Office365 subscription

 

[Joe4]

The Office365 subscription

Please then update your Profile, as described in that link, so people will easily be able to see what version you are using.