How to make a formula from a text string?

Hi

I am trying to make a formula from a text string. This works to some extend, but I cant get it completely right.
I have entered text in
A1: ='C:\2008.xls]January'!C
B1-4: 1-2-3-4
Then i make a cell in C1 which takes $A$1&B1
C2 is $A$1&B2 etc...

This gives me a formula in C1, from which I copy the values to D1 - The formula in D1 works if I doubleclick on the cell and press enter. But in my worksheet I have a couple of houndred of these cells, and double clicking each one of these is not an option. I thought pressing F9 would help, but Excel doesnt recognize the text as a formula... How do i do that?

I really hope you can help!!!

Enter this formula in C1, and copy down:

=INDIRECT(RIGHT($A$1,LEN($A$1)-1)&B1)

The RIGHT function is used, in order to drop the "=".

HTH

Jason

Thanks for your reply, but this also just gives me a text string that isnt being used as a formula

Please post up a copy of your workbook so we can take a look at it.