First off, it bugs me that you obfuscate the facts and then come back and change the rules after code has beeen supplied to you. Why don't you spell out all the rules up front in the first place?
Second, it is Howard's code you chose to adopt and I did not bother to analyze it beyond the first weakness of the comma delimiter.
If I knew all the rules, I may answer differently. What different permutations of "some site" can there be and do you always want to peel off only the first part delimited by a space?
Without knowing all the rules... you could check UBound($SiteParts2)>1 and Join() back the second and third (or more) elements... or you could use a combination of Instr() and Substr().
_________________________
Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.