'data cleanup' problem

I have a string of data. It was Copy/pasted from web into Word. Then saved as txt file and imported into Excel.
However the original data had a simple table formating witch now in Excel apears as a form of 'emptines' before and after the data.Just like you get from pressing spacebar only longer and selects as one symbol.
I tried standart Ctr+H replace method but it doesent work. Excel seems not to be able to recognize that emptines.
Is there a way to clean this out of the data?
Because the macros won't work on the data because of this.

the spaces are probably non-breaking spaces (a common alignment tool in html, which compresses white space) - you can use find & replace by first entering a cell for editing, select one of these spaces, ctrl+c, exit the cell then paste this character into the find box of find+replace.

HTH

I did try that already, but the find&replace tool doesent recognize that non-braking space. when I paste it in nothing happens. here is a sample.( U can see the space when entering the cell editing - cursor seems to be a bit 'away' form the data)

hmm... character 9, eh?
Try =clean(A1)
copied down

hth