S
Student
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
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