Split values in cell by custom delimiter using VBscript

I have have the following data in excel in one cell

Pankaj sharma;#234;#khushal verma;#786;#parul datta;#456;#

I would like to convert it to this using vbscript:

pankaj sharma

khushal verma