Street and Locality segregation

[roma83]

I have been given a list of addresses however data of each address (street and Locality) are clustered in one column.

I need to segregate the street from the locality. However please note that there is a range of localities that needs to be retrieved and not just one.

Example attached

I was using the formula below, but to choose random cells and apply it accordingly for each and every locality I might as well do them manually
=IF(ISERROR(FIND("ATTARD",A20,1)),"","ATTARD")