one rough and ready way to convert numbers stored as text into numbers is put
the number 1 in a blank cell somewhere on the worksheet. copy the number one
then select all the numbers which are saved as text and use paste special and
then choose the function check box multiply by. All the numbers will be
converted and then can be used to do calculations.

Hope this helps.

"RajenRajput1" wrote:

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.