i have a formula in cell A2 =Trim(C2)
and i want to propagate it to the rest of column A

For Example:
A3 =Trim(C3)
A4 =Trim(C4)
....etc

the problem is when i am drag cell A2 down ,using the handle,
i am getting the copy of the value from cell A2 and when i click on cell A3
it shows formula =Trim(C3) but it has the value of A2 cell.

Please advice...thank you


please advice...thank you

Toolsoptionscalculation set to automatic


Regards,


Peo Sjoblom

"Student" wrote:

i have a formula in cell A2 =Trim(C2)
and i want to propagate it to the rest of column A

For Example:
A3 =Trim(C3)
A4 =Trim(C4)
...etc

the problem is when i am drag cell A2 down ,using the handle,
i am getting the copy of the value from cell A2 and when i click on cell A3
it shows formula =Trim(C3) but it has the value of A2 cell.

Please advice...thank you


please advice...thank you

thank you very much this was very useful

"Peo Sjoblom" wrote:

Toolsoptionscalculation set to automatic


Regards,


Peo Sjoblom

"Student" wrote:

i have a formula in cell A2 =Trim(C2)
and i want to propagate it to the rest of column A

For Example:
A3 =Trim(C3)
A4 =Trim(C4)
...etc

the problem is when i am drag cell A2 down ,using the handle,
i am getting the copy of the value from cell A2 and when i click on cell A3
it shows formula =Trim(C3) but it has the value of A2 cell.

Please advice...thank you


please advice...thank you