ModTrim

Option Explicit
Public Function Trimmer(tmpString As String)
Dim tmp1 As String
Dim trimit As Boolean
Do
tmp1 = Mid$(tmpString, 1, 1)
If tmp1 = " " Or tmp1 = vbTab Then
trimit = True
tmpString = Mid$(tmpString, 2)
Else
trimit = False
End If
Loop Until trimit = False
Do
tmp1 = Right$(tmpString, 1)
If tmp1 = " " Or tmp1 = vbTab Then
trimit = True
tmpString = Mid$(tmpString, 1, (Len(tmpString) - 1))
Else
trimit = False
End If
Loop Until trimit = False
Trimmer = tmpString
End Function

Public Function MidTrim(sString As String, Start As Long, Optional Length) As String
If IsMissing(Length) = False Then
MidTrim = Trimmer(Mid$(sString, Start, Length))
Else
MidTrim = Trimmer(Mid$(sString, Start))
End If
End Function