Question : vba remove last vbcrlf
Answered by : vastemonde
' Removes the Line Break from the string if my string Ends with Line Break
Sub RemoveLineBreak(myString) If Len(myString) > 0 Then If Right$(myString, 2) = vbCrLf Or Right$(myString, 2) = vbNewLine Then myString = Left$(myString, Len(myString) - 2) End If End If
End Sub
Source : https://stackoverflow.com/questions/10024402/how-to-remove-line-break-in-string | Last Update : Sun, 31 Jan 21