CODEWITHSUNDEEP
excelexcel-formula
worisi24
worisi24

Reputation: 139

How to auto generate text with alphabets in Excel?

I'm trying to mass-produce a list such as,

Type A Type B Type C .. ... .... Type Z

How can I do it with Excel? I will be generating not just "type" but any other text combined with an alphabet on the right.

Upvotes: 0

Views: 300

Answers (1)

BigBen
BigBen

Reputation: 50007

Perhaps like this:

="Type " & CHAR(ROW(A65))

enter image description here

Or if you're dragging across instead of down:

="Type " & CHAR(COLUMN(BM1))

Upvotes: 3

Related Questions