Create Single Cell Lists from Text Strings With ';' Semi-Colon Delimiter

[NeoTheNerd]

I would like to build a list within a single cell from a sting stored another cell. The string has a semi colon delimiter ';' to separate the string SMTP, smtp, X400, FAX. Unfortunately the x400 portion of the string also has semi colons which need to be kept. Its delimiter is a second semi colon ';;'.

I need some help expanding this answer from yesterday, which provides an example of the output i need - Create single cell list from another cell containing a text string as does the below table.

String	List (Output)
SMTP:userS1@thetest.com;X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=S1\;G=user\;I=P\;;smtp:user1@test.local;FAX:User P. S1[userS1]@test.local	SMTP:userS1@thetest.com X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=S1\;G=user\;I=P\; smtp:user1@test.local FAX:User P. S1[userS1]@test.local
X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=41\;G=user\;	X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=41\;G=user\;
SMTP:user2@thetest.com;X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=2\;G=user\;;smtp:user2@test.local;FAX:user 2[user2]@test.local	SMTP:user2@thetest.com; X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=2\;G=user\; smtp:user2@test.local FAX:user 2[user2]@test.local
X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=17\;G=user\;;FAX:user 17[user17]@test.local	X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=17\;G=user\; FAX:user 17[user17]@test.local
SMTP:user3@thetest.com;X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=3\;G=user\;;smtp:user3@test.local;FAX:user 3[user3]@test.local	SMTP:user3@thetest.com X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=3\;G=user\; smtp:user3@test.local
X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=4\;G=user\;;smtp:user4@test.local	X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=4\;G=user\; smtp:user4@test.local
FAX:user 6[user6]@test.local;X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=6\;G=user\;	FAX:user 6[user6]@test.local X400:C=GB\;A= \;P=TEST\;O=Exchange\;S=6\;G=user\; smtp:user6@test.local
smtp:user5@test.local	smtp:user5@test.local

 

[NeoTheNerd]

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,";SMTP",CHAR(10)&"SMTP"),";smtp",CHAR(10)&"smtp"),";X400",CHAR(10)&"X400"),";FAX",CHAR(10)&"FAX")