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?
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.
 
Back
Top