Hi.

How do you remove trailing spaces?


I have copied over some statement data from my online banking with HSBC.

Column A has all the debits. Column B has all the credits. Column C has
the current balance.

Column A somehow has values stored as text and the values have trailing
spaces. For example, instead of "34.22" there is "34.22 " inserted.

This means that I cannot make any calculations on the numbers in column A.

I have tried using the Trim function to remove the trailing space, but even
after a paste values, the space is still there.

Does anyone have any other ideas?

The method I used was to put in column D, =trim(a1). Then in column E I
pasted values from column D. I noticed that the spaces were still there,
which means converting to a number did not work.

Any help would be appreciated as I have many many rows of data.

Thank you.