Drag down TRIM formula - Relative references not working

[phil34]

Hi,

I have a list of parts in Column A, in "General Format". These combine Letters and Numbers. However, the data, as I received it means there are spaces after the Letters/Digits.

So I am trying to make this data usable.

In Cell B2, I have the formula =TRIM(A2). This works.
But when I drag this formula down column B, the result is still TRIM(A2), even though the formula changed correctly to TRIM(A3), TRIM(A4)..etc.

How can this be? There is much data, so I don't want to have to enter by hand!!

NB . The data in column A was previously upon receipt of the format: "PartNumber ". (i.e. With apostrophes)..I got rid of the apostrophes by a simply copy and repaste. But perhaps something still remains?

 

[VoG]

Is calculation set to Automatic?

 

[phil34]

No it was on Manual. I have set the Options/Calculation setting to Automatic now....and it works!!

Thanks!!