Thread
:
how to use Excel to generate alphabet serially
View Single Post
#
4
Max
Posts: n/a
=CHAR(ROWS($A$1:A1)+64)
=CHAR(COLUMNS($A$1:A1)+64)
If you want the fill in lower case: a - z
just change the "64" to "96" in the formulas above
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Reply With Quote