separate city and state into different cells

  • Status: Closed
  • Prize: $10
  • Entries Received: 6
  • Winner: osiullah

Contest Brief

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. Video explanation attached in file below.

Must show formula as well.

file location is:

[login to view URL]:f:/g/Evm3pZyAG0dCvlEhRF2PnWsBLJT7CbBe6cR1TwES1dY-Xw?e=7SOf8n

Recommended Skills

Employer Feedback

“Good freelancer! Fast and easy to work with. A+”

Profile image chucksebass318, United States.

Top entries from this contest

View More Entries

Public Clarification Board

  • sergiuloghin
    • 3 weeks ago

    The file you attached is not the file from your video. Can you attach the file in which you want to split the city and state?

    • 3 weeks ago
  • osiullah
    • 3 weeks ago

    I have understood your job perfectly.

    I can do some samples right now to show you and You can check my YouTube Channel " Web Scraping Service " to see my experience and qualifications.

    Message me to start right now.


    • 3 weeks ago

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!