Text and cell numbers together

QuestionEdit

hi Sixthsense!

I place a number in cell A5. In cell C2 I want to show text and a cell address together, such as:

cell A5 contains today's IBM stock price.

Here's the question: When I move the contents of cell A5 to, say, cell B8, I want the contents of cell C2 to reflect the move by now showing:

cell B8 contains today's IBM stock price.

what formula is to appear in cell C2?

chris

AnswerEdit

In C2 cell press = and mention the cell reference like the below: =A5

Place the cursor in A5 cell and do Cut and paste in somewhere of the worksheet and you can notice that the C2 cell formula will be targeting the newly pasted area.