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?
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.