Originally posted by mbonfyre
strValue = Left(strValue, Len(strValue) - Len(vbNewLine))
Don't forget to use the $ in function like Left$ to avoid double conversion when dealing with 'Strings'.