I'm trying to match and format Japanese street names, and I have used Highlight Cell Rules / Text that Contains: *-*-
2-4-1 Marunouchi Chiyoda-ku
2-7-1 Marunouchi Chiyoda-Ku
2-7-1 Marunouchi Chiyoda-Ku
That worked, but I have false matches I want to avoid:
Senador Dantas street 7th floor - Centro - RJ.
Euljiro 2-ga Jung-gu Seoul
Nihonbashi Chuo-ku Tokyo 103-8011 Japan
I'm guessing that a formula may work, but I'm clueless in London...
Any help would be greatly appreciated.
I want to match Digit(s) Hyphen Digit(s) Hyphen Digit(s) SPACE, and then highlight those cells a certain color.
Bookmarks