ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to evaluate a text expression as formula ? (https://www.excelbanter.com/excel-programming/275644-how-evaluate-text-expression-formula.html)

Krzysztof Klimczak

How to evaluate a text expression as formula ?
 
Hi all,

I have, I hope simply, problem that I can't solve.

I have a text in the cell that is the formula I want to have calculated in
the other cell.
Example:
Cell A1 contains "date()" as text.
Now in cell A2 I want to put a function that takes a value of A1 ("date()")
and calculate it as formula giving as result the equivalent of "=date()"
formula in that cell.

Does anybody know how to do it ?

Regards,
Krzysztof





All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com