There's a couple of issues here Shades. First being that Clean() <> Trim(). Second, Trim() is available in Excel VBA either as a VBA String function or can be accessed in the Excel Class as well. Not true for Clean(), it can only be accessed via the Excel Class, different object libraries. E.g., the following errors out:
Sub test()
Dim y As String
'error
Let y = Clean("tester 2")
End Sub
And the following demonstrates the difference:
Sub test2()
MsgBox Len(Trim$("Tester 1 "))
MsgBox Len(WorksheetFunction.Clean("Tester 1 "))
End Sub
To get a better understanding of the forces at play here, I recommend reading about both in the Excel help file (not VBE help).
Daxton A., glad to hear your quandary is sorted.