Excel 2007 : How to search and return all similar values in a different cell

This might be a very easy question to experts but it bothers me...
Please help me in using match or vlookup or find function...
I'd like to return all similar values into a cell if it contains certain text. For example:

List of data as below:

Glasgow
Glasgow South
Glasgow north
Gla lala
xyz987

If I type 'GLA' in cell A1, then I'd like to see all results contains 'GLA' all returned in Cell A2.
I know we can use Ctrl+F option to highlight the data column and search that way but I am after a formular to show only the results contains certain text typed in Cell A1.

Appreciate any effort
Best regards,