Multiline text box adds the carriage return symbol (Square) to the cell?

[Noki]

Hi All,
In the past everyone has been very fast and helpful with my problems so thanks for that!

I have a new issue which google can't seem to answer, I have a Multi-line text box in a form which populates a merged will with its content, however it also adds the Carriage Return symbol (Square) into the cell, can anyone tell me how to fix this to stop it from being entered, or how I would go about parsing the entry of that particular symbol?

Thanks,
Chris

 

[Kenneth Hobson]

Replace as I did.

Sub t()
  Dim s As String
  s = "Hello" & vbCrLf & "World!"
  Range("A1").Value = s
  Range("A2").Value = Replace(s, vbCrLf, vbLf)
End Sub

 

[Noki]

Thanks that works great, and I can even reference the Text Fields' Name within the Replace rather then using the variable making it a one liner :D