Closed Thread
Results 1 to 2 of 2

Separating strings into substrings.

  1. #1
    Guest

    Separating strings into substrings.

    Your formula does not work. I followed your exercise however it gives me an error of value:
    Had to change "," for ;
    =LEFT(A2;FIND(";";A2)-1)
    I use Microsoft Excel 2003

  2. #2
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Separating strings into substrings.

    Problem:
    Separating the addresses in column A into 3 columns: city, state and zip.

    Solution:
    Using the LEFT, MID, RIGHT, FIND and LEN functions, as follows:
    To extract City:
    =LEFT(A2,FIND(\"\",\"\",A2)-1)
    To extract State:
    =MID(A2,FIND(\"\",\"\",A2)+2,2)
    To extract Zip code:
    =RIGHT(A2,5)


    Address_________________City____________State___Zip
    New York, NY 10164______New York________NY______10164
    Chicago, IL 60616_______Chicago_________IL______60616
    Los Angeles, CA 90099___Los Angeles_____CA______90099

Closed Thread

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