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 vote212 views1 answer
Excel date to unix timestamp
VBA
0 vote227 views1 answer
Vbscript check if string contains
VBA
0 vote215 views1 answer
Excel vba automatic calculation
VBA
0 vote219 views1 answer
Set column width of datagridview vb.net
VBA
0 vote238 views1 answer
Group controls programmatically vb
VBA
3 votes218 views1 answer
Vba make long from two words
VBA
0 vote233 views1 answer
Excel vba DisplayAlerts
VBA
0 vote204 views1 answer
Vbnet check if string is only symbols
VBA
0 vote245 views1 answer
Excel vba round to whole number
VBA
0 vote197 views1 answer
Excel vba concatenate range
VBA