I need to replace a non printable character, A small white square

Similar Threads:

1.I need to replace a non printable character, A small white squ

It's an unknow file but opens in excel. There is a white box where there is a 
carriage/return. I want to find all the boxes and replace with the <br>. When 
i Copy and bring the character over here it's shows up as nothing. It's some 
kind of unicode character. 






"JLatham" wrote:

> What are you copying from and to?  I mean what applications? Excel? Notepad? 
> into what? An .htm file page?
> 
> If it's being copied to an .htm file, try replacing the non-printables with 
> the <br> html tag - which is the equivalent of linefeed w/carriage return. 
> <br> = Break.  If you'r unfamiliar with html, you need to type all of that, 
> including the leading and trailing <> symbols.
> 
> "Melissa" wrote:
> 
> > I have a discription for an item i'm uploading on to my website. But it won't 
> > upload the small white square or rectangle. I need to replace that item with 
> > a hard enter. Anyone have any suggestions?
> > 

2.Replace non printable characters

I have a column that has a series of non printable characters, mainly the 
sqaure character.  I want to replace them with a space.  I tried the CLEAN 
function but it replaces the characters with nothing & therefore joins words 
together.  TIA
-- 
Tony

3.Imported Data: Replace Non printable character with a space

I have some alphanumeric data imported from a Database. If the user hit
the "enter" key when they type the text into this DB, I end up with 
'square' ie looks like CHAR(10) within the text.

If I use the Clean function it gets rid of it but I need to replace i
with a space. I have also tried doing a replace, but can't "Find" th
character

Does anyone have any suggestions?

Thanks

Kare

4.Search and replace for non printable characters

Hi Bernie,

Is there a chr limit in the cell for this Replace method?
I have a cell with 867 chr, Replace did not work, but it worded when I 
deleted down to 854.  Any reason?

Thanks.
Howard

"Bernie Deitrick" wrote:

> Ric,
> 
> I'm sorry, I completely misread what you wanted.  Try this
> 
> Sub Replace()
> Selection.Replace What:="卢", _
> Replacement:=Chr(10), LookAt:=xlPart, _
> SearchOrder:=xlByRows, MatchCase:=False
> Selection.WrapText = True
> End Sub
> 
> HTH,
> Bernie
> MS Excel MVP
> 
> "Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
> news: XXXX@XXXXX.COM ...
> > Ric,
> >
> > Try this, to replace them with a space
> >
> > Sub ReplaceChr10()
> >     Selection.Replace What:=Chr(10), _
> >      Replacement:=Chr(32), LookAt:=xlPart, _
> >      SearchOrder:=xlByRows, MatchCase:=False
> > End Sub
> >
> > or this, to simply remove them:
> >
> > Sub ReplaceChr10Part2()
> >     Selection.Replace What:=Chr(10), _
> >      Replacement:="", LookAt:=xlPart, _
> >      SearchOrder:=xlByRows, MatchCase:=False
> > End Sub
> >
> > HTH,
> > Bernie
> > MS Excel MVP
> >
> > "ricl999" < XXXX@XXXXX.COM > wrote in message
> > news: XXXX@XXXXX.COM ...
> > > Hi
> > >
> > > Using Excel 2002
> > >
> > > I have a number of cells with abc卢xyz卢opq ... . I want to search and
> > replace
> > > the '卢' character for 'alt-enter' i.e. the enter key pressed whilst the
> > 'alt'
> > > key is pressed.
> > >
> > > How do you do this.
> > >
> > > I have tried recording a macro while doing this but all that is shown
> > > changed is '卢' to chr(10). If i try apply this s&r then the cell is
> split
> > to
> > > a new line for each '卢'
> > >
> > > Any ideas.
> > >
> > > PS 'alt-enter' gives a soft line feed in the cell.
> > >
> > > regards
> > >
> > > Ric
> >
> >
> 
> 
> 

5.Replacing Non Printable Characters - Sorted Now

thanks :) simple but work perfectly 

Regards
Przemek

A3214 @Eclipse.co.uk>pisze:

>> I have included a bit of code when saving the data
>> i.e. Replace(textbox, Chr(13), "")
>> and it seems to work ok
>> 
>> also used it to cycle through the existing cells to remove previous 
>> occurrences
>> 
>> Regards to all
>> Jim Burton
>> 
>> "SA3214 @Eclipse.co.u>>"< wrote in message 
>> news: XXXX@XXXXX.COM ...
>>>>I have a userform in which comments are entered in a Multiline Textbox.
>>>> After transferring the contents of the textbox to a cell I find that it 
>>>> contains a non printable character symbol at the end of each line.
>>>> How can I
>>>> a) prevent this from happening and
>>>> b) replace the existing non printable characters with Alt&Enter
>>>>
>>>> Regards and TIA
>>>>
>>>> Jim Burton
>>>> 
>> 
>> 
>> 

6. Clean non printable characters and replace with space

7. How Can I find and replace symbols in excel data ( white square)

8. Viewing non-printable characters