If you search google groups for split (or split97, split was added with xl2k),
you'll see some real-life examples of how useful spit can be.

I think most users of xl2k+ are happy it's there.

davidm wrote:

Thanks Dave for this other dimension viz using the JOIN FUNCTION as a
complement to reverse the process. Your example as well as Leith Ross's
settles the way the SPLIT is used. It is a pity, as I remarked earlier,
that as a function, the Split should have very low utility rating. It
would appear that for what it accomplishes, there are probably a
handful of better ways to explore. Little wonder, the Help file notes
waxed darn little about it. The good is that it broadens the choices we
have, anyhow (<g).

Thanks again, Dave.

--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=481725

--

Dave Peterson