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?
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?