If you are on xl200 or later

Code:
--------------------

Dim x
x=split("jack;dave;john",";")
msgbox Join(x,vbLf)
--------------------


--
jindon
------------------------------------------------------------------------
jindon's Profile: http://www.excelforum.com/member.php...o&userid=13135
View this thread: http://www.excelforum.com/showthread...hreadid=383041