Results 1 to 3 of 3

Formula to separate Cell with City and State with a comma and space in between

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2005
    Posts
    67

    Formula to separate Cell with City and State with a comma and space in between

    Hello. I have a large sheet with a cell that has the address in the format (City, ST), for example:

    in A1: Philadelphia, PA
    in A2: New York, NY

    I need to be able to separate this into two cell, with city in one cell and state in the other.

    1) For the the state, I know that I can do right(a1,2) and this works;
    2) Can you separate the city, which would be to the left of the comma? I am struggling since the city in each of the cells are different lengths.

    I appreciate your guidance!

    Thank you!!
    Last edited by jshrader; 02-02-2012 at 12:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1