Microsoft KB Archive/65399

{|
 * width="100%"|

Excel: Creating a Series of Letters

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 1.5, 2.2, 3.0, 4.0
 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a
 * Microsoft Excel for OS/2, versions 2.2 and 3.0

-

SUMMARY
To create a series of letters from A to Z in Microsoft Excel, do the following:


 * 1) Type the letter A in cell A1.
 * 2) In cell A2, type =CHAR(CODE(A1)+1).
 * 3) Select cells A2 through A26.
 * 4) From the Edit menu, choose Fill Down.

Reference(s):

&quot;Microsoft Excel Function Reference,&quot; version 4.0, pages 49 and 56

&quot;Microsoft Excel Function Reference,&quot; version 3.0, pages 29 and 32

Additional query words: 2.20 4.00a 2.21

Keywords :

Version :

Platform :

Issue type :

Technology :