This VBA function will remove the last character from a string: Function CutOffLastChar(str As String) CutOffLastChar = Left(str, Len(str) - 1) End Function
Function CutOffLastChar(str As String) CutOffLastChar = Left(str, Len(str) - 1) End Function