CODEWITHSUNDEEP
excel
user41758
user41758

Reputation: 343

Excel autofill with letters and numbers

In excel I would like to auto fill with this pattern

R1a
R1b
R1c
R2a
R2b
R2c
R3a

ECT. Any ideal How?

Upvotes: 1

Views: 182

Answers (2)

Scott Craner
Scott Craner

Reputation: 152505

Put R1a in the A1:

Then in A2:

="R" &MID(A1,2,LEN(A1)-2)+ IF(MOD(ROW(1:1),3)=0,1,0) & CHOOSE(MOD(ROW(2:2)-1,3)+1,"a","b","c")

Then copy/drag down.

[1]: https://i.sstatic.net/iMh

Upvotes: 1

pnuts
pnuts

Reputation: 59475

A shorter version, in Row1 and copied down to suit:

="R"&INT((ROW()-1)/3)+1&CHAR(97+MOD(ROW()+2,3))

Upvotes: 2

Related Questions