Extract Strings between multiple special characters in a cell

[Rob48]

I need to extract data from an excel file that comes as single or multiple strings separated by semicolons, into a list of the individual strings without the semicolons.  I'm figuring RegEx is my start point but I'm not too strong with that tool and can't figure it out.

Here's my example:

What I have	What I need
ABCDEFG;	ABCDEFG
ABCDEFG; HIJKLMNO;	HIJKLMNO
ABCDEFG; HIJKLMNO; PQRSTU;	PQRSTU
ABCDEFG; HIJKLMNO; PQRSTU; VWXYZ12;	VWXYZ12
891011A; QWERTY; UIOP;	8910111A
ABCDEFG; HIJKLMNO; PQRSTU; VWXYZ12; 34567A;	34567A
	QWERTY
	UIOP

In theory there could be no limit to the number of individual strings within the cells so i'd like something that could manage that, although so far I've only seen 4 or 5 at a time in my data.  

Thanks for any help you can provide.

[TimN · Accepted solution]

Maybe like this...

[TimN]

You can split to rows as well - put a record ID tool before the parse and you can tie the rows back.

[Rob48]

Delimiters!  Of course.  Thank you!