Here is my issue:
For example, ‘txt’ is coming from a cell in a worksheet entered by the user.

Function Test(txt as string) as string
If (txt = "comm. lse" Or txt = "ME") Then
Do this
Else
Do that
End If
End Function

If the user enters Comm Lse, the statement will “Do that� instead of “Do
this�. Any suggestions? (drop downs are not welcomed by the users...yet!)