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: copy to clipboard 


AA * 6; AA + ZZ + ZZ + AA; AA + ZZ + AA + ZZ; AA + ZZ + AA + AA + AA; AA + AA + ZZ + ZZ; AA + AA + ZZ + AA + AA; AA + AA + AA + ZZ + AA; AA + AA + AA + AA + ZZ; AA + AA + AA + AA + AA + AA;

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