Replacing Non Printable Characters

[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

[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

"SA3214 @Eclipse.co.uk>" <sa3214<No Spam> wrote in message
news:[email protected]...
>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
>

[Przemek Karniewski]

thanks simple but work perfectly

Regards
Przemek

„SA3214 @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.uk>" <sa3214<No Spam> wrote in message
> news:[email protected]...
> >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
> >
>
>
>