Copy text after last comma in cell

[Juleew]

I am using excel 2007, I have a column of cells that contain text that is separated by commas. Each cell may have 3 commas or 5 or 2 commas. What I need to do is copy the last text after the last comma in the cell.

example
xxx,yyy,zzz copy to another cell the text zzz
xxx,yyy copy to another cell the text yyy
xxx,yyy,zzz,aaa copy to another cell the text aaa

 

[texasalynn]

try this

Excel Workbook
	A	B
2	XXX,YYY,ZZZ	ZZZ
3	xxx,yyy	yyy
4	xxx,yyy,zzz,aaa	aaa
Sheet2

 

[Jonmo1]

Welcome to the board...

Perhaps

=TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",LEN(A1))),LEN(A1)))

Hope that helps.

 

[Juleew]

Reply to texasalynn
That worked great but it is only copying the first 3 chars after the last comma.

 

[Juleew]

OK the jonmo1 worked perfect, it took all characters no matter how many commas are in the string.

 

[Special-K99]

Welcome to the board...

Perhaps

=TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",LEN(A1))),LEN(A1)))

Hope that helps.

Ouch! That is so clever! Bravo!

 

[Jonmo1]

Ouch! That is so clever! Bravo!

Learned it right here on this forum...Can't remember for sure who I got it from, probably Aladin...

 

[Juleew]

Well I search tese forums and if I can't find it and end up asking. everybody is so responsive and supportive here.

 

[texasalynn]

Reply to texasalynn
That worked great but it is only copying the first 3 chars after the last comma.

it looked like from your example that was what you wanted. But glad that you found a solution.

 

[jc352]

I have a similar issue. I am trying to copy text from one cell to another. The first cell contains a very long text string with the information separated by commas and enclosed by quotation marks. How do I pick and choose the text within the quotations I would like to extract? I would like to achieve this using a formula.

Example of A1:
"Internal/External Agent Calls Report","Report data from: Saturday, March 22, 2014 to Saturday, March 29, 2014","Group By","Outbound Complete","Outbound InComplete","Internal Complete","Internal Incomplete"," # - Name","Number of Calls","Average Duration","Number of Calls","Average Duration","Number of Calls","Average Duration","Number of Calls","Average Duration",,,,,,,,,,,"Filters Applied:","Relative Date:",,"Agent Group Number:","Enterprise Group ID(s):",,"71","Agent Number:","30000-39999","Display Level:","Sort Order:","Enterprise Group, Agent Group, Agent, Call Detail","by ID","Start Time:","2014-03-22","Start Time:","End Date:","00:00:00","2014-03-29","End Time:","23:59:59","Time Zone:","LOCAL","38,39,40,41,45,46","Dialed Digits: ","200",," Tuesday, April 15, 2014 15:41:42","Page -1 of 1"

Example of output I would like:
A2
Report data from: Saturday, March 22, 2014 to Saturday, March 29, 2014
A3
Sort Order:
A4
Dialed Digits:
A5
200