I need text in excel spreadsheet split into different columns.

I need an admin assistant or someone with knowledge and experience of Excel and data entry who can kindly split text in one column into several columns in one day, please. The spreadsheet is 3092 rows.

The text is UK addresses (with only spaces, no other delimiters e.g. comma) and you will be splitting the various lines of the address (as it would appear in a letter) into columns titled the following:
- Address 1 (first line of address e.g. house number and street name; flat number and house/ building number and name; company name)

- Address 2 (second line of address e.g. area name, house/building number and street name or, whatever comes after the "first line" and before the City or Town name

- City (city or town name only e.g. London, Witney, Cambridge)

- County (usually ends in "-shire" and directly before the post code

- The post codes are already separated out.

Example 1:
High House 2 Coverly Road Crawley West Sussex SJ1 3LT
Address 1 - High House (house name)
Address 2 - 2 Coverly Road
City - Crawley
County - West Sussex

Example 2:
Flat 3 45 Adelaide Crescent Birlingham, Worcestershire, WR10 3AA
Address 1 - Flat 3 45 Adelaide Crescent
Address 2 - leave blank
City - Birlingham
County - Worcestershire

Feel free to contact me to work on this project and/ or if more details would be helpful in assessing the scope of the project. ✨