How to check if a string is existing in a column

Question

Hello All,

I am looking to write a formula for the below condition.

If Address column or City town column contains "Hong kong" then country field should be replaced by "China".

Note - the string Hong kong should be case insensitive

can anyone assist on this.

Input -

AddressCity or townCountry1234 ABCD RD, HONG KONGHONG KONG 11111Hong Kong

Output

AddressCity or townCountry1234 ABCD RD, HONG KONGHONG KONG 11111China

Rana_Kareem · Accepted Answer

Hi @Saravanan13 ..

IF Contains([Address], "Hong Kong")
OR
Contains([City or town], "Hong Kong")
THEN "China"
ELSE [Country]
ENDIF

Write it below the Country field in Formula Tool.