Splitting comma separated cells

Hi, I have an excel file with 4 columns, one of which contains addresses. The addresses are separated by ";". For example, one of our cells may contain:
12 Sesame Street; Brooklyn; New York;
I would like to separate this cell into 3 cells if possible.
Can anybody please help?
Thanks

Make sure you have 3 vacant columns to the right of the column with the address's
Select column
From the Data Menu Select Text To Columns > Delimited Option > Next button > Select Semicolon option > Finish Button

Thats brilliant, thanks very much!

Happy to be of assistance & thanks for the feed back

Bet you never thought anyone esle would say thanks, did you?

Thank you mudraker

It solved my problem as well

And thank you Dangermouse500, for asking the question

No I did not.

It always a pleasure to hear when I have helped someone - thanks for the feed back