How to extract separated text by many commas in Excel?

pheakdekim pheakdekim is offline

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!

« Re: Calculated % completed by date | Re: freeze first colums and hide one colums »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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