Extract Text After Second To Last Comma in A Text String

[ChaidaJones]

Hello, I have the following text string and I need to see how I can keep the text AFTER the second to Last Comma.

I have:
12/08/2015 15:36 EL PASO, TX 79906, 12/12/2015 14:12 HERMOSILLO, SON 83000

I want to keep:
12/12/2015 14:12 HERMOSILLO, SON 83000

I have been using a RIGHT function but since the length of the text string varies, I have to go in manually and clean it up. Need to know if there is an easier way. I have seen how you do it to the LEFT of a comma but not to the RIGHT. Thanks for your help!

[Gatti]

Try this:

Please Login or Register  to view this content.

I put the string in A1

[ChemistB]

Try this

=TRIM(MID(A1, SEARCH("^",SUBSTITUTE(A1,",","^", LEN(A1)-LEN(SUBSTITUTE(A1,",",""))-1))+1,9999))

This
SUBSTITUTE(A1,",","^", LEN(A1)-LEN(SUBSTITUTE(A1,",",""))-1)
will replace the next to last comma (no matter how many comma's exist) with a "^". The rest finds that ^ and takes everything to the right of it.

[ChaidaJones]

Thank you Gatti, it works for that example but I have multiple sets of data and they vary all the time, Here is one of the most complex strings. It did not work with this one.

12/04/2015 15:50 Celaya, GTO 38110, 12/07/2015 11:30 EL COLORADO, QRO 76246, 12/17/2015 10:55 LAREDO, TX 78045, 12/17/2015 14:26 LAREDO, TX 78045, 12/17/2015 22:06 LAREDO, TX , 12/18/2015 21:49 DALLAS, TX

I want to keep which is the data after the second to last comma:
12/18/2015 21:49 DALLAS, TX

Can you help with this? Thanks.

[AlKey]

Try this

Please Login or Register  to view this content.

[ChaidaJones]

Thank you ChemistB!! That worked great! Just saved me a ton of time!!

Thanks for all your help everyone.

[ChaidaJones]

That worked as well AlKey. Thanks Again!!

[ChemistB]

Glad to help