It includes a column which gives me data such as 12,456.78 USD

I'm trying to convert it into values that I can use, but what's bugging me is the space between the number and the currency. I can't seem to shift it.

I know it's code(160) but I can't seem to get rid of it using either find and replace or Text to columns.

In the words of Donny Osmond...Someone help me...help...help me...help me please!

sorry....