Excel Split Single Cell Array into Multiple Cells

An application I use exports strings of data in an array in one cell, like so:

"data1"= value1; "data2"= value2; "data3"= value3; "data4"= value4; "data5"= value5;

I'd like an equation or macro or something that could split it like this:

------------------------------------------------------
|   |  data1  |  data2 |  data3  |  data4  |  data5  |
------------------------------------------------------
| 1 |  value1 | value2 |  value3 |  value4 |  value5 |
------------------------------------------------------
| 2 |  value1 | value2 |  value3 |  value4 |  value5 |
------------------------------------------------------
| 3 |  value1 | value2 |  value3 |  value4 |  value5 |
------------------------------------------------------
.....

Is this possible?

Excel 2003 on Windows XP