How can I reference one text-based cell value in another text-based cell value?
I want to use Sachin in cell A1 of column B of the table below (which should change dynamically)
||My Name is Sachin(from A1)|
Tried & for referencing
Didnt find the solution.