isnumber cari lebih dari 1 kata, misal multi kota


=IF(ISNUMBER(FIND("bali",B2)),"BALI",IF(ISNUMBER(FIND("jakarta",B2)),"JAKARTA",IF(ISNUMBER(FIND("tangerang",B2)),"TANGERANG",IF(ISNUMBER(FIND("malang",B2)),"MALANG",IF(ISNUMBER(FIND("surabaya",B2)),"SURABAYA",IF(ISNUMBER(FIND("bandung",B2)),"BANDUNG",IF(ISNUMBER(FIND("semarang",B2)),"SEMARANG",IF(ISNUMBER(FIND("solo",B2)),"SOLO",IF(ISNUMBER(FIND("bekasi",B2)),"BEKASI",IF(ISNUMBER(FIND("bogor",B2)),"BOGOR","NO"))))))))))