anybody have a Split() replacement?

[Blakieto]

I'm trying to get an in-house excel plugin to operate on the macs we have. I've just figured out that the Split() function does not exist on the Mac version of VBA...

(Split() takes a string and a delimiter, and returns an array of strings broken up by the delimiter.)

Has anyone a version of Split() they wrote, or know of a public version?

I could write one... but I'm hoping someone has an efficient version that they share.

-Blakieto

[ALaRiva]

Try the example at this website - LINK

[Blakieto]

Thanks!

I've also located this:
http://support.microsoft.com/default...b;en-us;188007
Which contains source for Join, Split, InStrRev, Replace and Reverse functions.

-Blakieto