Results 1 to 9 of 9

Seeking Formula to separate cells that contain specific terms

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    LA
    MS-Off Ver
    Excel For Mac 2011
    Posts
    99

    Seeking Formula to separate cells that contain specific terms

    I have thousands of data entries (each in their own row, all in one column) and need to separate the basic info. In the example below, say you want to isolate the Town names by entering a formula that can produce a TRUE or FALSE result. Is there a way to use the FIND function and a pool of terms to isolate cells that contain excess data (i.e.- produce a FALSE result for cells containing any words from a term pool like : "Police, Park, Power, Water, Community, Bakery, Grocery, Field, Garden, Post Office, School" etc... ) ?

    Pic of sample spreadsheet with desired result:
    Screen Shot 2014-03-18 at 3.14.09 AM.png


    example as text:
    A2 = Springfield
    A3 = Springfield Police Department
    A4 = Springfield Community College
    A5 = Springfield Park Of Recreation
    A6 = Des Moines
    A7 = Des Moines Power & Water Company
    A8 = Des Moines Sunrise Bakery
    A9 = Des Moines Post Office
    A10 = Des Moines Grocery Store
    A11 = Lancaster
    A12 = Lancaster Baseball Field
    A13 = Lancaster Botanical Gardens
    Last edited by syncguy; 03-18-2014 at 06:33 AM. Reason: ..in-case you can't see the pic..

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 06-01-2011, 12:24 PM
  2. Separate string and place into specific cells
    By genestoy in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 09-02-2010, 02:34 PM
  3. Compare Specific Cells From Three Separate Worksheets
    By Outlaw 13 in forum Excel General
    Replies: 2
    Last Post: 03-27-2009, 11:07 AM
  4. Seeking Information Formula for specific logic
    By sweeetk in forum Excel General
    Replies: 1
    Last Post: 11-21-2008, 05:57 PM
  5. Help Printing Rows with specific terms.
    By DrOct in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 06-24-2008, 03:36 PM

Tags for this Thread

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