If we want to display a number series, say 1-100, in column A, we can simply drag the cursor to expand the series. But if we need to display an alphabetic series, say we require A-Z, in column A, unfortunately dragging will not work. One option is to key each alphabet manually. That works, but it can be very time consuming.
To display the A-Z series without typing them manually in Excel, you can use the “char” function. Enter the following formula in cell A1 and drag it all the way to cell A90.
You will notice cell “A65″ to “A90″ will display the A-Z letters.