Extracting text from a string

[excelhelp18]

Hi,
I have addresses of cities in a col.

Sample Address: Badulipara Jardaguri, KAIBORTA GAON, KAIBORTA GAON, IN, ASSAM, GOLAGHAT, 785619, India

I want to extract last four text within "comma or ','" i.e ASSAM GOLAGHAT 785619 INDIA

I tried doing it through text to column but I didnt worked for me as the address are quite absurd and are not having consistent length. I just need to extract last 4 text within comma. That would work for me.

Please assist.

Thanks

[Haseeb Avarakkan]

Hello try,

=TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",250)),1000))

Change A1 to your actual cell reference