separate cityy and state into different cells in excel

Hali: Closed
Zawadi: $10
Wasilisho Zilizopokelewa: 7
Mshindi: haleem0786

Winner

Maelezo ya Shindano

I need to split up the city and state into 2 separate cells. There is no delimiter so its too hard for me. First entry will be awarded. Need ASAP

file location is:

https://revamp365.sharepoint.com/:x:/g/EU9y2D-VJ8tKhG4HkX2dKvEBHQKRgpeKufuTK4qR-J3SRQ?e=pd5JYc

Ujuzi unaopendekezwa

Winner

Tuma Shindano kama Hili

Maoni ya Muajiri

“Great freelancer. Fast, accurate and good communication”

chucksebass318, United States.

Wasilisho kuu kwenye hili shindano

haleem0786 Pakistan

0
shark2345 China

0
zmhamdana Nigeria

0
mehedihassan4467 Bangladesh

0
TheAnsari97 Pakistan

0
abbasJz Canada

0

Angalia wasilisho zaidi

Bodi ya Ufafanuzi ya Umma

Serdouni
- Miaka 5 iliyopita
Your Work has been
- Miaka 5 iliyopita
haleem0786
- Miaka 5 iliyopita
Your work has been done . Inbox me and get the entire sheet. Thanks My Entry # 1
- Miaka 5 iliyopita
emamulbd
- Miaka 5 iliyopita
I'm ready to send your file within 1 minutes. Thanks
- Miaka 5 iliyopita
emamulbd
- Miaka 5 iliyopita
Job already done
- Miaka 5 iliyopita
haleem0786
- Miaka 5 iliyopita
Please see highlighted cells
- Miaka 5 iliyopita