Insert a value to a cell in excel using formula in another cell

Question

I need to insert a value to a cell in excel using formula in another cell.

Say

A1 = "Test"
B1 = formula to insert A1 to C1
C1 = A1

Can I write a formula in B1 to insert value in C1? I don't need any formulas in C1. If Yes, What should be the formula?

Answer 1

Select the cell where the formula should be entered.

Type = in the Button image formula bar (equal sign).

Choose one of the following options: choose the cell with the desired value or type the cell reference.

A single cell, a range of cells, a place in another worksheet, or a location in another workbook can all be referenced.

When selecting a range of cells, you can relocate the selection by dragging the cell selection's border, or expand the selection by dragging the corner of the border.