Series Fill

  • Thread starter Thread starter Serena
  • Start date Start date
S

Serena

I feel like I'm missing a step here but how do I create
cells 1A to 45A in a column without having to type in each
cell? I've tried to follow the instructions given in
excel but all that is happening is the cells just copy
exactly what I've typed (for example, 1A, 1A, 1A) - not
continued the numbers like (1A, 1B, 1C,) etc. Help!
 
Continued numbers as in 1A, 1B and so on (text you mean)?
If you want that you have to create a custom list
or use a formula like

="I"&CHAR(ROW(65:65))

you can copy that down 26 rows, select it and import is under
tools>options>custom lists
 
Hi
try
- enter 1A in cell A1 and 2A in cell B1
- select cell A1 AND B1
- drag this selection down
 
I think it doesn't support text strings, which is what a mix of letters and
numbers is.

You can try a formula like this, starting in ROW 1;

=1&(CHAR(65+ROW()-1))

but with this, you'll manually have to change the beginning from 1 to 2 when
you pass Z.
 
Back
Top