converting text to formulas

[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.

[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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Scot B" <[email protected]> wrote in message
news:[email protected]...
> 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.
>