To count the number of cells that contain specific part of text, you can use the function COUNTIF and you have to include *
into criteria. For example to count the number of cells, that include "London", you have to use the following formula:
This formula will find 4 matching cells. It counts the cells, that contain "London" at the begining or at the end or in the middle.