In many cases an alphabetic string is needed in certain Excel formula constructions. The easiest way to generate this string is with the following:
=TEXTJOIN(“”,,CHAR(64+ROW(1:26))) ‘ array-entered
which affords the string
Other character sets strings (such as alphanumeric) can be made in a similar manner.