Public Function TrimInPlace( _
ByRef rValue As Variant _
) As Variant Assuming
Dim S As String
S = " This is a sample. "
for example
TrimInPlace(S) = "This is a sample."
leaves
S = "This is a sample."See also: LTrimInPlace Function
RTrimInPlace Function
Trim Function (Visual Basic)rValue: String argument which is to have all surrounding space characters removed. Function also returns the "trimmed" value of rValue. Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.