converting text to formulas

S

Scot B

Greetings,

Is there a way to convert text to a formula?

I have a pattern of data that I am trying to convert to formulas. In one
column I have a pattern of A,A,A,A,B,B,B,B,C,C.... In the next column I
have numbers 1,2,3,4,1,2,3,4,...
Using the concatenate function I can generate a column of
=A1,=A2,=A3,=A4,=B1,=B2....

but this is just text. I really am trying to generate the values that these
cell references would represent. The goal is to present the DATA from cell
A1, A2, A3, A4, B1, B2...all in a long list.

Does this make sense? Can this be done?

Thanks a ton for your help!

Scot B.
 
E

Earl Kiosterud

Scot,

I'm presuming your A's and B's run down the column, one character in each
cell. If not, please describe more fully. If they're in columns C and D,
try:

=INDIRECT(C1&D1)

Copy down with the Fill Handle.
 
Top