Copying data from the web

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone
I am copying data from the web and pasting to a spreadsheet. I am having trouble with formulas, seems that weven though the cells are formatted text or number I can not use the cell content in formulas. What am I doing wrong
Thank
Jamie
 
Jamie

The numbers may have been imported as text. Simply re-formatting to "number"
will not change them.

Format an empty cell to number or general. Copy it and select your range of
data then Paste Special>Add>OK>Esc.

After this, you still may not get the results you want. In that case, there
could be HTML non-breaking space characters(160)in the data.

See David MCritchie's TRIMALL macro for further cleaning.

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

Gord Dibben Excel MVP
 
Thanks for the repl
I tried TRIMALL and that didnt seem to help either. Copy>Paste Special>Values only doesnt work. I also used EDIT>GOTO and could not determine what is in the cell. Is there anyway to copy(without formatting) and paste to a new location? either

----- Gord Dibben wrote: ----

Jami

The numbers may have been imported as text. Simply re-formatting to "number
will not change them

Format an empty cell to number or general. Copy it and select your range o
data then Paste Special>Add>OK>Esc

After this, you still may not get the results you want. In that case, ther
could be HTML non-breaking space characters(160)in the data

See David MCritchie's TRIMALL macro for further cleaning

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

Gord Dibben Excel MV

On Wed, 3 Mar 2004 11:56:08 -0800, "Jamie
 
It doesn't sound like it's a formatting problem to me. I'd try Gord's
suggestion of David McRitchie's TrimAll routine just once more.

And if that doesn't work, I'd spend some time trying to figure out what's in the
cell.

The good news is that Chip Pearson has an addin that can show you what
characters are there exactly--not just what they look like (spaces and
non-breaking spaces look the same, but behave differently).

http://www.cpearson.com/excel/CellView.htm
 
OK I followed the TrimALL route again....copy code from Dave----Alt F8>New copied code into module, saved went to my spreadsheet ALt F8, and ran macro. Download Chip's addin and the cells in question still have a 160 there, and apparently that is the problem. Did I do something wrong with the macro
Thanks
 
Back
Top