Bayview Boulevard Sydney 90 William St Sydney
Y Hotel Hyde Park 5-11 Wentworth Ave Sydney
Wyndham Vacation Resorts Asia Pacific Sydney 66 Wentworth Avenue Sydney
Y Hotel City South 179 Cleveland St Chippendale
Hyde Park Inn 271 Elizabeth St Sydney

I have this set of data with 8k records in which I need to separate out the address from the hotel name. The only help in this data is the address starts with a number. I can't use Text-to-Column coz neither it has any common delimiter nor it is of a fixed width. Can someone tell me how can I write a function to separate this out? Thanks