Results 1 to 2 of 2

Help Separating part of a cell into a new column

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    chicago, il
    MS-Off Ver
    Excel 2010
    Posts
    40

    Help Separating part of a cell into a new column

    Hello,

    I have a fun one that I would love some help with. Currently my sheet looks like this:

    Column A

    World Leader
    Obama (usa)
    Blair (England)
    Churchill (Englad)
    Chirac (France)

    I need a formula that will take the country in parenthesis and move it to the adjacent column next to the world leader's name. For example:

    Column A Column B
    World Leader Country
    Obama usa
    Blair England
    Churchill England
    Chirac France

    I have over 1000 historical leaders in my sheet. Any help is super-appreciated! Thanks!
    Last edited by richardwedamins; 06-20-2012 at 12:10 PM.

Thread Information

Users Browsing this Thread

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

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