I am compiling a relatively complex sheet with various Bloomberg functions, which are done by concatenate, and would like to document it clearly as well as for bug testing see both result and formula.
Thus I am after a function which will execute a text string as function - without using VBA as other people in my department are supposed to be able to understand it in years to come.
Hence I want to write e.g. Today() into Cell A1 and then write "Execute A1" into B1 so that I have the resulting date.
Then I have
A1 B1
Today() 11.2.2008
Bookmarks