UDF to remove "equivalent" expressions from a ";" delimited string

I'm trying to remove equal expressions from a string, the expression in the string are delimited by semi-colons
I thought I saw a VBA function that would take a delimited string and break it down into an array, but now I cannot find it!

an example of what I'm dealing with:

Formula:

Please Login or Register  to view this content.

the same coloured parts are equal to each other, therefore only one of them is required..
I can do the comparisons, if i can get the string broken down into an array

ANY help Much appreciated !

Note-
I'll be calling the function from another UDF in this case, if that changes anything

The function is VBA's Split.

Hrrm..guess the weekend ghosts are at work again....I did say Thanks, but it is not showing up here...at least on my end...so THANK YOU !!!