Exclamation Delete/cut some text in cell

[jagocoding]

hello all..
i confused with this problem.
cut or delete some text in cell...

i have 1.000.000 rows , wanna remove some text in cell..
example :

st. causeway bay kav.19 hongkong 12345
st. harbour rd.19 hongkong 12345
st. yamatee north rd.29 hongkong 12345

must change to :

- street. causeway bay hongkong 12345 --> kav.19 removed
- street. harbour rd.19 hongkong 12345 --> rd.19
- street yamatee north hongkong 12345 --> rd.29 removed

only street name and country name also zip code will be posted, number road and other text word must removed.

st to street can use replace function , but how to remove text number, road, and other text word.

any function or logic to do this ???.. please help me friends. this my first job at office.
i attached file here. "
thanks be4