| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
=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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
| How do I generate random numbers using dates in excel? | Excel Worksheet Functions | |||
| Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Hybrid Mode
