Public Function Del_Space(pStr As String) As String
Dim strTemp As String
Dim strSSN As String
Dim i As Integer
strSSN = pStr
strTemp = Right(strSSN, 1)
i = Asc(strTemp)
Do Until (i <> 10 And i <> 13 And i <> 32)
Do Until i <> 10
strSSN = Left(strSSN, Len(strSSN) - 1)
strTemp = Right(strSSN, 1)
i = Asc(strTemp)
Loop
Do Until i <> 13
strSSN = Left(strSSN, Len(strSSN) - 1)
strTemp = Right(strSSN, 1)
i = Asc(strTemp)
Loop
Do Until i <> 32
strSSN = Left(strSSN, Len(strSSN) - 1)
strTemp = Right(strSSN, 1)
i = Asc(strTemp)
Loop