I stopped using the Microsoft forums because I wasn't getting the email
notifications. Instead I moved to 'The Code Cage - Microsoft Office
Help - Microsoft Office Discussion' (http://www.THECODECAGE.com) to get
mail notifications. A lot of people instead get the VBN notification by
registering for the postings.

Here is some test code to help get the ascii characters in the cell.
Simply change the sheet names and cell address to one of the cells that
appearr to hae an extra character. the extra character may be another
invisible white character like a tab that is giving you the problem.
Once you know the character you can use the replace statementt to remove
the extra characters.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181707

http://www.thecodecage.com/forumz/chat.php