Remove space from cell

[verbena]

I have downloaded a large file on xls format with over 9000 lines. There is one column which contains numbers but the numbers have a space to the right which I am unable to format out so that I can use the column values to make calculations. I continue to get the #VALUE error as the formula does not accept the space to the right as a value. Can anyone help me remove the empty space from the right of these cells? Here is an example screenshot https://screencast.com/t/smdrz6Hb2E2L The 1st number you can see if flush to the right and xls recognizes it as a number. The one's under it, you will notice a space to the right. That space is what I am looking to remove in bulk. Can you please help?

 

[James006]

Hello,

Probably you are facing some ' invisible ' characters ...

These hidden characters can be a real headache ... !!!

Take a look at following :

https://www.mrexcel.com/forum/excel...elete-hidden-characters-text.html#post4960110

Hope this will help

 

[RasGhul]

Try

=trim(clean(A:A))