Can excels Split() function split a string up at multiple spots?

[111StepsAhead]

I have been reading about the function here: http://msdn.microsoft.com/en-us/libr...(v=vs.80).aspx However, it doesn't appear to be able to split a string up at multiple places.

Dim avarSplit As Variant
LastRow = Cells(Rows.Count, "Y").End(xlUp).Row
For x = 2 To LastRow
     Range("Y" & LastRow).Select
     avarSplit = Split(Range(ActiveCell.Value, "CC")
     avarSplit = Split(Range(ActiveCell.Value, "CD")
Next x

The above is what I am working with. avarSplit is an array which contains 2 values after I split it once.

If my string was someTextCCsomeOtherText and I did

avarSplit= Split(Range(ActiveCell.Value, "CC")

Then I would get an array like ("someText", "someOtherText"). From my tests I am not able to get an in between value.

Example: someTextCCsomeOtherTextCDsomeMoreText

where I need to extract the someOtherText. Does anyone have a good way to do this?