View Single Post
  #1   Report Post  
Lee Jeffery
 
Posts: n/a
Default Can't get rid of funny little boxes in imported data


Dave,

I finally found time to follow your suggestion and I am very grateful
to you for your assistance and to Chip Pearson for making his Cellview
add-in available.

Your Cleanemup macro works like a dream and I have added it to another
macro I use to format the spreadsheet as an order form .

I really need to learn the terminology as I found your original post
with this suggestion in the Microsoft newsgroup and could have saved
everyone some bother had I known that "funny little boxes" should
really be called non-printing characters.

Many thanks, again.

Lee Jeffery :)


--
Lee Jeffery
------------------------------------------------------------------------
Lee Jeffery's Profile: http://www.excelforum.com/member.php...o&userid=10889
View this thread: http://www.excelforum.com/showthread...hreadid=318991