PC Review


Reply
Thread Tools Rate Thread

How to extract separated text by many commas in Excel?

 
 
New Member
Join Date: Aug 2012
Posts: 1
 
      9th Aug 2012
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!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How from Word a list separated by commas convert to Excel? Gunjani Microsoft Excel Misc 1 5th Jun 2004 12:06 AM
Save .csv file. Decimals separated by commas belitre Microsoft Excel Programming 2 10th May 2004 11:36 AM
Separating texts separated by commas in a cell somto Microsoft Excel Discussion 1 22nd Apr 2004 03:09 AM
text separated by commas Benjamin Barreto Microsoft Excel Misc 1 7th Jan 2004 05:05 PM
parsing words in a cell separated by commas spjoseph0511 Microsoft Excel Programming 2 16th Dec 2003 10:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:07 AM.