Excel: Creating a Series of Letters
ID: Q65399
|
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:
- Type the letter A in cell A1.
- In cell A2, type =CHAR(CODE(A1)+1).
- Select cells A2 through A26.
- From the Edit menu, choose Fill Down.
Reference(s):
"Microsoft Excel Function Reference," version 4.0, pages 49 and 56
"Microsoft Excel Function Reference," version 3.0, pages 29 and 32
Additional query words:
2.20 4.00a 2.21
Keywords :
Version :
Platform :
Issue type :
Last Reviewed: March 21, 1999