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?