Need function to convert string to formula

[General Ledger]

Dear All,

Using Excel 2007: I used the Concatenate function to create a string that looks like a formula. I need a function that converts the string to a formula. I don't want to use VBA or macro.

For example, in cell A4 is the formula =CONCATENATE("=",A1,"!",A2,A3) Where A1 is the name of a sheet such as January, where A2 is a letter such as Z that is a column reference, and where A3 is a number such as 100 that is a row reference. The Concatenate function returns a string =January!Z100 I want Excel to interpret this string as a formula and show the value from sheet January, cell Z100.

It seems this should be easy but I can not find the solution. I almost wish the answer is complicated so I don't think I am so stupid. If someone provides a simple solution, I might have to surrender my Microsoft Certified Trainer and Certified Application Specialist certificates.

Best regards,

General Ledger

 

[meytithveasna]

Thanks,how convert from formula to text
like this Sum((200-100)*1.5) result 150 to ((200-100)*1.5)

 

[mikerickson]

I don't understand what you want.
You should post a new thread explaining what you want, with a few example of inputs and the desired results.

 

[meytithveasna]

In cell C5 i write a formula Sum((200-100)*1.5) i want it to be ((200-100)*1.5) in text string

How could it be?

 

[mikerickson]

Start a new thread. Post several examples of input and desired output.
Note that Sum((200-100)*1.5) is a string, and =Sum((200-100)*1.5) is a formula.

 

[meytithveasna]

Thanks Mike i use formulatext it is ok

 

[ExcelEngine]

I believe I have the same question, but from a different angle...
Am I understanding correctly from the previous replies that there's no going back from a =FORMULATEXT(A1) function?
If so, does anyone have a suggestion to copy a large hyperlink (formula-based) list from one sheet onto another sheet, in order to retain the hyperlinks?
I love the hyperlink formula, because it uses cell or named references, and can be auto filled (awesome for tables of contents, indexes, etc.).
My Hyperlink calls two values that, combined, are used in a sheet name (e.g. text values of F5="B₁" and F6="B₁₉" combined with a "," results in sheet "B₁,B₁₉")
=HYPERLINK("#'" & T($F$5) & "," & T($F$6) & "'!A1", T($F$5) & "," & T($F$6))
I worked it the hard way (Copied entire column and pasted the result string from =FORMULATEXT as text, then individually went through double-clicking and hitting enter in order for it to register as a formula). Is there an easier way to make the string register as a formula?
Thanks!