print view vs print - none printable chars

[lezawang]

Hi
I have this formula in a cell =CHAR(127)&CHAR(127)&CHAR(127)&"testing" so I got [][][]testing

When I print preview (I do not have a printer), I can see all these characters and testing in print view window? Does that mean even when I view them in Print Preview that means they still will not printed in hard copy?

Thank you.

 

[lezawang]

Sorry just to add something. Same apply on all other characters - I tried to type:

=char(1)
=char(2)
=char(3)
=char(4)
.
.
.
= char(31)

and then printview this column, I see all these "none printable" characters! Thanks

 

[RoryA]

Really -what do you see them as?

They won't actually print anyway.

 

[lezawang]

Yes I see these











































<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[lezawang]

wow i paste these chars here but they do not show!
I took screen shot of printprivew here

https://imgur.com/a/jzR8gPc

 

[RoryA]

You should not be able to see chars 1, 9, 10 or 13.