UR Welcome.

Also note that when you import/assign text from an external application/process/code, you will have a problem in differentiating, VBCRLF, VBCR, VBLF. All return as (a) pipe(s).

So use something like this
VB Code:
  1. Private Sub Command1_Click()
  2. strng = "Me" & vbCrLf & "My" & vbCr & "Myself" & vbLf
  3.     Text1.Text = strng
  4. strng = Replace(strng, vbCrLf, "")
  5. strng = Replace(strng, vbCr, "")
  6. strng = Replace(strng, vbLf, "")
  7.     Text1.Text = strng
  8. End Sub