Gord,

Excellent!!!!!!! Thanks for your suggestions.



Judd
"Gord Dibben" wrote:

Probably has some non-breaking spaces(char 160) and other junk.

Run David McRitchie's Trimall macro on it.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Or prior to the above.......

Download Chip Pearson's CELLVIEW add-in from

http://www.cpearson.com/excel/CellView.htm

Load through ToolsAdd-ins.

Select the data and Chip's add-in will show you what the characters are in the
cells.


Gord

On Thu, 31 Mar 2005 19:21:01 -0800, "jbsand1001"
wrote:

Thank you but I think the problem is that the data I am trying to copy and
paste is from a website and it maybe in HTML format?

I tried both suggestions but nothing. Anything else?




"Gord Dibben" wrote:

Format the cells as General.

Copy a blank cell then select your range of data and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 06:35:07 -0800, "jbsand1001"
wrote:

When I copy and paste information from a particular web site it will not
allow me to add/subtract the informaiton in my excel spreadsheet. I have
tried copying the information and paste special as value only to no avail.
Any help would be appreciated.


Thank You,


Judd Sandstrom