Drag and Fill

[Marc Boken]

How can you drag and fill text in a column? For example
in A1 you have "AAAA", in B1 you have "AAAB", C1 you
have "AAAC" and I want to fill the rest of the column with
AAAD...AAAE...and so on to ZZZZ. It does it automatically
with numbers, but is it possible to do with text. Please
help for Excel 2000.

Marc Boken

 

[Chip Pearson]

Marc,

I don't believe that this is possible.

 

[Frank Kabel]

Hi
only possible with some formulas or VBA. Not with Autofill!

 

[Bill Kuunders]

As always Chip knows his stuff.
There is of course a long winded way..........................
do it with numbers in 4 columns
find and replace the numbers with letters
and concatenate the columns into one.

you will run out of rows though 26 to the power of 4 = 456976

we only have 65536 rows in excel

Regards
Bill K