You probably have a required blank space (  in HTML).  You could
convert them to spaces  manually  by   using  Alt+0160  on numeric keypad,
or if you have a laptop  Fn+Alt+0160 on the numeric keypad.

But it is a lot easier to install a macro into your personal.xls  and use it anytime
you need it.    See     TrimALL in
   http://www.mvps.org/dmcritchie/excel/join.htm#trimall
instructions at the top of the page point you to
   http://www.mvps.org/dmcritchie/excel/getstarted.htm
if you are not already familiar with installing and using macros.

Whether you install the macro or not instructions to find out what you have
can be found at the above location (#trimall   and  #debugformat)

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

"mtress" <mtress@discussions.microsoft.com> wrote in message ..

HTML has a habit of leaving junk in cells.  Non-breaking spaces for one.

To clean up the junk you can use TRIM and CLEAN and Edit>Replace if you know
which character it is.

Download Chip Pearson's CELLVIEW add-in from

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

Load through Tools>Add-ins.

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

If carriage returns you may be able to Replace them using ALT + 0010 or 0013

Most likely David McRitchie's TRIMALL macro will be of greatest assistance.
Cleans up what TRIM and CLEAN miss.

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

Gord Dibben Excel MVP