AutoFill

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding a formul to the next cell only with the next cell number 1
Excel Fill issue 2
IF THEN ELSE question 1
Continuous Invoice Nos. 3
Compare the value of 2 cells and get Flase/true statement 3
Combining Text From Cells 3
Autofill Problem 2
change change cell reference to Absolute reference 5

Top