Converting data from a pasted document

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

Hi,

The Clean Function within excel may help you. Cannot promise results but it is worth a go.

Sometimes what looks like spaces in excel are really those non-breaking HTML
spaces.

David McRitchie has some code to fix this kind of thing at:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

And if you're new to macros, you may want to read David's intro:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

You can get a copy of Chip Pearson's CellView addin.
http://www.cpearson.com/excel/CellView.htm

It'll show you what you have in the cell.


Dave wrote:
>
> 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

--

Dave Peterson