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

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?

excel excel-formula

Solution 1:^[1]

If there it is next to the cell AND has no value in B2, it is possible, otherwise it is not.

Use Split()

Split(CONCATENATE("Text for B1#Sperator$$",A1),"#Sperator$$",FALSE)

It really depends.

EDIT Out dated. Only works in google sheets.

Without using VBA or formulas in column C you can't achieve this.

A simple solution using formulas:

In cell C1, paste the following formula and drag it down:

=IF(B1=1;A1;"")

So if the content of cell B1 is equal to 1, your cell at column C will display the respective value of the same row at column A.

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1
Solution 2	dot.Py