Hi,
not sure what you mean you can reference A1 in C1 just entering in c1

=A1

let's say B2 has a name Peter

with A1 having the formula =B2 will show Peter

if you enter in cell C1 the formula given it will show Peter as well

"JCC" wrote:

Cell A1 content is "=B2". I want to reference A1 and get the contents of B2.