Hello. I have a problem with some data which is together like this:
Brunkebergstorg9Stockholm103Sverige
111KlaraÖstrakyrkogata7Stockholm52Sverige
Drottninggatan8836StockholmSverige
Brunkebergstorg9StockholmSverige10327
All street number and ZIP codes are together with streetnames and city names.But I would like to get to this form:
Brunkebergstorg 9 Stockholm 103 Sverige
111 Klara Östrakyrkogata 7 Stockholm 52 Sverige
Drottninggatan 8836 Stockholm Sverige
Brunkebergstorg 9 Stockholm Sverige 10327
Is it possible to make VBA code or something that which will but spaces to the text when he finds that letter and number is together?
Bookmarks