Cannot remove crlf from textbox

Hi guys,

Is there a way to replace the new-line character in a textbox?
I've attached a sample file with expected result.

Thank you.

You have both vbCr and vbLf, so your code should be

If InStr(TextBox1.Text, vbCrLf) > 0 Then
    Label1.Caption = Replace(TextBox1.Text, vbCrLf, "")
End If

Replace this

Replace(TextBox1.Text, Chr(10), "")

With

Replace(TextBox1.Text, vbCrLf, " ")

Edit: Slow Testing/Typing

Thanks a bunch!