Hi
I'm a board member in a voluntary organisation and would like to plot our members adresses in a map using MapPoint.
Our memberlist is in excel with the addresses stated as following: Street #, floor. door/side. (example: Peder Jakobsens Gade 8, 2. th. - (in English: 8 Peder Jakobsens Street, 2nd floor, right))
The thing is just, that MapPoint doesn't recognize a street address if I have informations like floor, door etc. so I need a formula that removes the comma and everything after it.
I found this link: http://www.mrexcel.com/board2/viewtopic.php?t=216656 but that seems to delete everything BEFORE the comma, and I can't see how I turn it around - I'm not an excel pro..
SO - Who will help me?
The output data should be (in example) Peder Jakobsens Gade 8 - no comma's and nothing after the comma...
I'm a board member in a voluntary organisation and would like to plot our members adresses in a map using MapPoint.
Our memberlist is in excel with the addresses stated as following: Street #, floor. door/side. (example: Peder Jakobsens Gade 8, 2. th. - (in English: 8 Peder Jakobsens Street, 2nd floor, right))
The thing is just, that MapPoint doesn't recognize a street address if I have informations like floor, door etc. so I need a formula that removes the comma and everything after it.
I found this link: http://www.mrexcel.com/board2/viewtopic.php?t=216656 but that seems to delete everything BEFORE the comma, and I can't see how I turn it around - I'm not an excel pro..
SO - Who will help me?
The output data should be (in example) Peder Jakobsens Gade 8 - no comma's and nothing after the comma...