It's unclear which formulas you have generating which characters. For
example, are the ampersand and colon being generated as well? If so,
there's no need to. If formulas for C2, D2, E2, and F2 generate A, 3,
A, and 10 respectively, you could use...
=AVERAGE(INDIRECT(C2&D2&":"&E2&F2))
Hope this helps!
In article . com,
wrote:
Basically I'm building a text string using various functions that ends
up looking like a reference:
textstring might look like "A" & "3" & ":" & "A" & "10"
(The actual way I build up this string uses several different functions
to get the column and rows I need)
I then want to use this string in the AVERAGE function.
AVERAGE(the textstring)
Is there a simple TEXT to ADDRESS RANGE function that anyone knows
about?
Thanks!