Excel help - Seperating out delimited strings

[Domo]

I have an Excel spreadsheet with 3 columns.
Company Name, Company Number, Email Address,

The Email address column contains multiple addresses per row seperated by a semicolon. What I need is one row per email address.

I've meddled with Text to Columns but this isn't the desired result. As an example I neeed to get this..

<Row1> ABC Inc, .234, [email protected];[email protected]

into this..

<Row1> ABC Inc, 1234, [email protected]
<Row2> ABC Inc, 1234, [email protected]

 

[Domo]

Yeah I get the Text to Columns bit but its the VB I'm struggling with (not being a VB developer!).
Any help would be greatly appreciated

I've scanned Google results but not found anything which retains all other columns when copying.

 

[Domo]

Good job fretted - genuine thanks for getting me out of an almost impossible situation!!

Thanks to you too PMKeates for your advice.