Data extracted and placed in separate columns

Job ID: 30723997

Budget: $10 – $30 USD

I am importing customer and vendor addresses in quickbooks online. The excel file has the complete address in one cell. I need individual cells for street, city, state and country.

Mobile and work numbers are also in one cell and need to be in its individual cell