I copied a table of information from a page on the internet.

The information pasted into columns and rows, but the data does not work in
calculations or lookups.

When I look at a particular cell there appears to be spaces in front and
behind a piece of data. The data can be text or numbers. I tried a Find
including spaces, but the data was not found.

How do I convert data such as I described so it is usable?

Thanks