I am importing reports from a website. All the numbers come with a space
after the last number, so it is not recognised as a number by excel. what is
the easiest way to remove this space so I can work with the numbers?

eg. 6502<space (it is one space, and always to the right of the number)