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:

  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):

"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
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.