Extract text - country from address

[David_H1]

Hi,

How could I extract text - country from address field?

221B Baker St, London NW1 6XE, UK

It should return value after last comma, and remove/trim the space value before UK.

I am struggling with Extract function here.

Thank you.

[Suvrutt_Gurjar · Accepted solution]

Please try 

INDEX( SPLIT([Address], ", "), COUNT( SPLIT([Address], ", ")))

[David_H1]

Hi Sir,

Perfect!

Many thanks, and for the book as well - enjoying it so much :).

[Suvrutt_Gurjar]

You are welcome. Thank you very much for your appreciation.