Re: Can't get rid of funny little boxes in imported data

[Lee Jeffery]

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?action=getinfo&userid=10889
View this thread: http://www.excelforum.com/showthread.php?threadid=318991

[Dave Peterson]

But "funny little boxes" is more fun!

Glad you got it working.

Lee Jeffery wrote:
>
> 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?action=getinfo&userid=10889
> View this thread: http://www.excelforum.com/showthread.php?threadid=318991

--

Dave Peterson

[Gord Dibben]

And makes more sense to most of us<g>

Gord Dibben Excel MVP

On Thu, 25 Nov 2004 20:40:35 -0600, Dave Peterson >
wrote:

>But "funny little boxes" is more fun!
>
>Glad you got it working.
>
>Lee Jeffery wrote:
>>
>> 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?action=getinfo&userid=10889
>> View this thread: http://www.excelforum.com/showthread.php?threadid=318991