delete everything in a cell before a comma

[thekingoflondon]

Is this possible?

Say I had data in a cell that had a load of commas in it, and I wanted only the text after the last comma, is this possible? Unfortunately I cannot get excel to split data into cells by commas and then delete as there isn't a uniform number of commas in the cells in question.

Thanks in advance

 

[thekingoflondon]

e.g. so how would i use a formula to make

"310 West 43rd Street, 5th Floor, New York, NY 10036, US"

into

"US"

 

[Domenic]

Try...

=TRIM(REPLACE(A1,1,SEARCH("^^",SUBSTITUTE(A1,",","^^",LEN(A1)-LEN(SUBSTITUTE(A1,",","")))),""))

Hope this helps!

 

[NBVC]

Try:

=RIGHT(A1,LEN(A1)-FIND("@",SUBSTITUTE(A1,",","@",LEN(A1)-LEN(SUBSTITUTE(A1,",","")))))

 

[thekingoflondon]

Try...

=TRIM(REPLACE(A1,1,SEARCH("^^",SUBSTITUTE(A1,",","^^",LEN(A1)-LEN(SUBSTITUTE(A1,",","")))),""))

Hope this helps!

yes that's great!!

thanks a lot