Vba remove last vbcrlf

' 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: stackoverflow.com

Similar codes

1 vote316 views1 answer
Highlight selected cell in excel vba
VBA
0 vote362 views1 answer
Vba boolean to string
VBA
0 vote306 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote364 views1 answer
Pivot data source not accepting table named range vba
VBA
1 vote396 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
2 votes313 views1 answer
Excel vba extract file name
VBA
5 votes343 views1 answer
Xl vba double quotes in string literal
VBA
0 vote336 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote335 views2 answers
Get excel file from email attachment in vba
VBA
0 vote337 views1 answer
Excel vba calculate
VBA