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

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