Excel Convert Text to Formula

  • Thread starter Thread starter Salvador Garcia
  • Start date Start date
S

Salvador Garcia

I have a formula that changes every day because is
related to another spreadsheet that it is changed every
day. I was able to create a cell
='V:\CREWSCH\[BCS020404WED.XLS]MON'!$J$144
with all the information I need in the formula base on
the date on the spreadsheet, however this cell is in text
form and I would like to find out if I can transform it
into a formula.
 
Salvador said:
I have a formula that changes every day because is
related to another spreadsheet that it is changed every
day. I was able to create a cell
='V:\CREWSCH\[BCS020404WED.XLS]MON'!$J$144
with all the information I need in the formula base on
the date on the spreadsheet, however this cell is in text
form and I would like to find out if I can transform it
into a formula.
Click to expand...

Hi Salvador
have a look at the INDIRECT function. Though this will work only if the
other workbook is open:
=INDIRECT(text_cell_reference)

Frank
 
Back
Top