Excel Convert Text to Formula

  • Thread starter Salvador Garcia
  • 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.
 
F

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Use TODAY() function as the criteria in a SUMIF formula 1
Searching the formula (not the value) for a text string 1
Using formula to convert date result to text 3
Excel Formula or VBA Code 2
If Formula and Dates 4
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Formula for Dates and CF Colour then convert to Text 3

Top