Perhaps I'm not understanding the question properly, but I'm assuming you want to convert a string like

38403 SAINT-JEAN-D'HERANS 241

to a string like

SAINT-JEAN-D'HERANS

for 30,000+ records. This can be done very easily in Excel using the LEN(), RIGHT() and LEFT() functions in that order ie. find the length of each string, then chop off 6 to the left and 4 to the right. Then read into MapPoint.

Hope this helps

David