Text format problem after copying from a web page

  • Thread starter Thread starter Sandra
  • Start date Start date
S

Sandra

What I ended up doing for the below was highlighting the "blank" characters
and doing a find/replace to replace them with nothing. I still have some
kind of format problem because my vlookup isn't working. Anybody know what
might be going on and a way to fix it? I've tried changing the contents to
text, general, etc. No luck.
Does anyone know how to remove blank spaces at the end of a cell when you
Click to expand...
exported something >from a webpage into excel? i've tried formatting, custom
number, find and replace and the only >thing that works is manually going
into the cell and backspacing to the last number and then it >works. of
course i'm trying to do this for a vlookup so i need to get it to work.
 
Didn't see yesterday's suggestion. Still can't see it in my newsreadt -
don't know why. I followed your like to it though and no this isn't really
my problem. I was able to get the blanks out by doing the find and replace.
My problem is after that - some sort of text format issue. For example cell
A1 (Value=11111) isn't recognized by my vlookup. If if copy the cell to
another cell - same problem. If, instead, I do =(A1*1) it works fine. What's
up with that?
 
If the cell is formatted as text (or the value is entered with a leading
apostrophe, like: '12345), then that value is text and text entries don't match
numeric entries.

I find it very easy to convert the text values to numeric values by copying an
empty cell and then selecting the offending range and Edit|paste special|and
check the Add button.

But I've found that when I change spaces to "nothing", the value is changed to
numeric.

I don't know why it didn't work for you.

(I was guessing the HTML non-breaking spaces were still in the value.)
 
Back
Top