Hi,

could anyone help me out with the following:

I've got a column which contains addresses (e.g. A1 = mountainroad 17 , A2
= mainstreet 168a , etc.) In order to work with this data I will need to
seperate the streetnames from the housenumbers. Would anyone have a
suggestion on how to do this?

As there are many lines, it takes quite some time to do this manually.

KR,

Lucas