How to extract separated text by many commas in Excel?

Discussion in 'Microsoft Excel Worksheet Functions' started by pheakdekim, Aug 9, 2012.

  1. pheakdekim

    pheakdekim

    Joined:
    Aug 9, 2012
    Messages:
    1
    Likes Received:
    0
    Please help me!
    I have the following text in a cell:
    Cell A1: PHUM POU BAK KA, KHUM DAMREI CHOAN KHLA, SROK STUENG SAEN, KAMPONG THOM

    Result i want:

    Cell B1: i want this --> KAMPONG THOM (i want to extract the right text after comma; including space)
    Cell B2: i want this --> STUENG SAEN ( i want to extract text that is before the right text, exclude the text SROK that is after STUENG SAEN)


    Thank you so much for your help!
     
    pheakdekim, Aug 9, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    find and replace - replace data in rows to separated by commas

    Guest, Apr 14, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    455
    Gord Dibben
    Apr 15, 2006
  2. Alan

    So many commas

    Alan, May 24, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    150
    Harlan Grove
    May 24, 2007
  3. Guest

    Help! I need a formula to add numbers separated by commas within

    Guest, Jul 25, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    8
    Views:
    2,129
    Roger Govier
    Jul 27, 2007
  4. mishak
    Replies:
    0
    Views:
    187
    mishak
    Dec 9, 2009
  5. dab

    Sort data separated by commas

    dab, May 13, 2010, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    272
    Ashish Mathur
    May 14, 2010
Loading...

Share This Page