You might need to post a copy of the Excel file with instructions if anyone wants to take this on. As for me, I'm not seeing the purpose of Application.Caller since AFAIK, that doesn't return a number (at least that's what I expect vbErr would be). Rather it would return an object, object name, or #REF error value, so I can't see the point of formatting text for that. You'd need a reference to Microsoft XML library (I think version 3) and maybe eliminate any line with this in it: Application.Caller - or explain what it's for and perhaps an Access equivalent can be determined.
Using the numbers you provided, I get this in Access:
Flughafen Innsbruck, Fürstenweg, Höttinger Au, Hötting, Innsbruck, Tirol, 6020, Österreich
but I suspect you want what you posted and not that. So I reversed the numbers (figuring that might be why) and got this
Ceerigaabo ???????, ???? Sanaag, Soomaaliland ??? ???????, Soomaaliya ???????
so probably not right either.
As for your list, if you have lat / long in separate form fields there's no need to split, manually or otherwise. If it's one string, still maybe not a Split function case if that's what you meant by split, but I'm on the fence with that at the moment. I'm seeing this as a one click operation so far. I haven't looked at your file yet - busy watching my team lose again (Blue Jays).
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.