Split addresses from 1 col to multiple cols in a spreadsheet

I have a spreadsheet with approx 900 addresses in 1 column. I need the addresses to be split out into specific columns.

e.g. I have "10 Downing Street, London, SW1 1AB, United Kingdom" as one value in one column and I need it split into the following columns:

- Building name/ number: 10
- Address line 1: Downing Street
- City: London
- Postcode: SW1 1AB
- Country: United Kingdom

I estimate this is a 3-4 hour task