Drag and Fill

  • Thread starter Thread starter Marc Boken
  • Start date Start date
M

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
 
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
 
Back
Top