How to check if a string is existing in a column

[Saravanan13]

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 -

Address	City or town	Country
1234 ABCD RD, HONG KONG	HONG KONG 11111	Hong Kong

Output

Address	City or town	Country
1234 ABCD RD, HONG KONG	HONG KONG 11111	China

[Saravanan13]

Sorry forgot to add the full condition

If Address column or City town column contains "Hong kong" then country field should be replaced by "China". Else the value should be the same in country column.

[Rana_Kareem · Accepted solution]

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.