converting text to formulas

  • Thread starter Thread starter Scot B
  • Start date Start date
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.
 
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.
 
Back
Top