Return Multiple words from a Split

[Quality_Assuran]

Hi community

I need help with an expression.

I have a column from a web form that returns "Country: United States" or "Country: Peoples Republic of China". I am setting up an email automation to respond to an enquiry and would like to refer to the country that is being enquired about. 

I know how to use Index(SPLIT()) to get one word out of the list but is there a way to do the opposite and omit one word from the list. In this case "Country: ". 

Or is there another way to return the opposite of LEFT(), and omit it that way.

Thanks in adavance

[1minManager]

Try INDEX(SPLIT([ColumnName],":"),2)

This basically split it into a 2 item list e.g. Country, Peoples Republic of China then tells it to get the second item in the list.

Simon@1minManager.com