Autofilling Alpha-Numeric numbers with column headers

[JackofAllTrades]

Edited to clarify question..

I have to complete an unfiltered table using formulas....The columns g
from 1-16 and the rows g from A-Z. In row A it goes....1A, 2A,3A,4A al
the way to column 16, which is 16A. The same happens for Row B. I hav
to create a formula to fill in the rest of the rows/columns with th
same sequence. What formula do I use? Or does this require a macr
formula? I'm really stumped on this one and have to have this compete b
Monday morning...HELP

 

[Claus Busch]

Hi Jack,

Am Sun, 3 Jun 2012 11:15:59 +0000 schrieb JackofAllTrades:

I have to complete an unfiltered table using formulas....The columns go
from 1-16 and the rows g from A-Z. In row A it goes....1A, 2A,3A,4A all
the way to column 16, which is 16A. The same happens for Row B. I have
to create a formula to fill in the rest of the rows/columns with the
same sequence. What formula do I use? Or does this require a macro
formula?

A1 = 1A, B1 = 2A,
A2 = 1B, B2 = 2B and so on?


Regards
Claus Busch