Sort data using String in Single Cell

[samonedome]

Hi all,

I want to try and sort data quickly.

I have cells that are addresses with multiple strings. Here is an example:

"7-9 Tryon Street, London, SW3 3LG"

Some cells may have more variables within them, but this is the general format.

I need to get all cells that have a certain city within the text. As an example, I would want to highlight and sort this cell and all other cells with the text "London" in them.

Thus, once I had successfully run the necessary formula/Macro, I would only see the rows that have "London" in the C column.

Here is a sample:

Thanks for the help

[samonedome]

Also, I have tried to "split text", but due to the fact that some addresses have far more strings than others, it means that the columns do not match up evenly.