Filling a Series of Alpha Characters

[carl]

I have a need to fill series of Alpha charachters. For example,

A,B,...Z

or

AB,BB,CB...ZB

Is there an excel funtion that can do this for me ?

Thank you in advance.

 

[JE McGimpsey]

One way:

Choose Tools/Options/Custom Lists. Enter

A <return> B <return>

through Z, then click Add.

You can then enter A in a cell and use the drag handle to fill down.

 

[Bernie Deitrick]

Carl,

To fill from A to Z, type A in one cell, B in the next, select both and drag
using the fill handle.

To fill beyond Z, you can use a function, which will also start at A:

=IF(ROW(A1) > 26, CHAR(INT((ROW(A1) - 1)/ 26) + 64) & CHAR(MOD(ROW(A1) - 1,
26) + 65), CHAR(ROW(A1) + 64))

for filling down. To fill accross, change each ROW function to COLUMN.

Note that this gives the standard column letter type fill after Z: AA, AB,
AC. Of course, it could be modified to give just about anything you want,
but I already had this function available.

HTH,
Bernie
MS Excel MVP

 

[Max]

A,B,...Z

Filling across:
Put in the starting cell, say in C1: =CHAR(COLUMN(A1)+64)
Copy C1 across 26 cols to AB1

Filling down:
Put in the starting cell, say in C1: =CHAR(ROW(A1)+64)
Copy C1 down to C26

AB,BB,CB...ZB

Just concatenate a "B" to the formulas above, viz.:

In C1: =CHAR(COLUMN(A1)+64)&"B"
Copy across

In C1: =CHAR(ROW(A1)+64)&"B"
Copy down

 

[kkknie]

A bit of a kludge, but here's an option.

Put the values 65 through 90 in successive rows (say A1-A26).
In row B2, enter the formula =CHAR(A1)
Copy down.

To do the second option use the formula =CHAR(A1) & "B"

K

Edit: Or you could use Bernie's much better solution!

 

[Bernie Deitrick]

JE,

I'm pretty sure that the alphabet is a standard list. It's only been a
couple of months since I got my latest machine with Office XP, and XP has
it, though I didn't add it. But I can't really remember what was standard
when I started with XL 2000.

Bernie

 

[Gord Dibben]

Carl

The A to Z can be manually entered then select that range and
Tools>Options>Custom Lists and "Import from Cells"

Now whenever you want that list, enter A in A1 and right-click and drag down.
Release button and "Fill Series".

To get AB, BB, have your A to Z in column A then in B1 enter =A1&CHAR(66)

Double-click on B1 fill handle to copy down.

As an aside.......To get a list of CHARs.

In A1 enter =CHAR(ROW()) and drag down to A255

Gord Dibben Excel MVP

 

[JE McGimpsey]

Hmmm..., it doesn't come standard with XL03 from MSDN. Nor with
XL98/01/v.X/04

I think it *should* come standard, but it would have to be localized...

I made it "standard" when I included code to add it in my standard
startup add-in.

 

[Bernie Deitrick]

JE,

My Excel also has a list of states before the alphabet, and a list of state
abbreviations after it, things that I definitely didn't add. Must have been
the customization of the master that my IT used to create all of our
machines.

Bernie