Hello All!
Does anybody know to concatenate texts and values from different cells to get a valid working formula?
To illustrate:
Let's presume I have cells with values "Sheet2", "!", "B", and "2". How can I concatenate these to behave as if it were a formula =Sheet2!B2 to get data from cell B2 in Sheet2?
Any suggestions would be appreciated.
Thanks and best regards,
T.
Does anybody know to concatenate texts and values from different cells to get a valid working formula?
To illustrate:
Let's presume I have cells with values "Sheet2", "!", "B", and "2". How can I concatenate these to behave as if it were a formula =Sheet2!B2 to get data from cell B2 in Sheet2?
Any suggestions would be appreciated.
Thanks and best regards,
T.