Contenate in formula string

  • Thread starter Thread starter Rodolfo
  • Start date Start date
R

Rodolfo

i'm trying to use the concatenate function to build a formula string
refering to different cells. I'm trying to get this formula string:

=[VALORIZACION.xls]DOS001!$C$27

Using ="=[VALORIZACION.xls]"&A22&"!$C$27" in wich A22 value is DOS001.

Since this doesn't work i copy paste special values and get the
strings, but the remain as text, i have to clic on every cell and place
the cursor at the end of the string and the press enter for the string
to work as a formula.

Any suggestions how can i solve this?

Thanks in advance
 
You must log in or register to reply here.

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

Inter sheet formula won't format properly 6
combining row values into one cell while filter is active 6
Excel formula referencing cells 4
String as Formula without Macro / VBA 4
Remove certain characters from a text string 6
Possible to select a string in a locked cell? 1
Does Excel support mixed formatting of a string in a formula cell,yet? 5
Building closed workbook file path within an Index Function 6

Back
Top