Replacing Non Printable Characters

S

SA3214

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
 
S

SA3214

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
 
P

Przemek Karniewski

thanks :) simple but work perfectly

Regards
Przemek

„SA3214 @Eclipse.co.uk>†pisze:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UserForm; Textbox; Multiline; NonPrintable Characters 3
Macro for deleting non-printable characters from EXCEL 2
Replace non printable characters 4
Replacing Printable Ascii Codes 1
Display of non-printing ASCII characters 1
Non standard characters 4
Test for string of space chars? 3
How do I install Microsoft Equation 3.0 back to Office 365? 0

Top