Excel 2007 : Help with splitting contents of a cell

Morning,


I can't remember how to split the contents of a cell into different cells.

Currently I have:
A1 = 41-33.91
would like to have:
B1 = 41
C1 = 33
D1 = 91

A2 = 41-38.00

B2 = 41
C2 = 38
D2 = 00
etc.

Ideally would like to have it in VBA because I have 5345 rows that needs to be split, but a formula would be fine. I would just copy the formula into the other cells.

Thanks in advance,

George