Results 1 to 6 of 6

How to extract the universities out?

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2010
    Location
    South Carolina
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to extract the universities out?

    I have a column of data looking like this:

    School of Business, Rockefeller College of Public Affairs and Policy, State University of New York at Albany, 1400 Washington Avenue, Albany, NY 12222
    Bowling Green State University, Bowling Green, OH 43403
    Marketing Department, Wharton School, University of Pennsylvania, Philadelphia, PA 19104

    I want to keep only the university information which means transforming into sth like this:

    State University of New York at Albany
    Bowling Green State University
    University of Pennsylvania

    Does anybody have an idea on how do I do this?
    Last edited by Guang; 10-29-2010 at 08:04 PM.

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