You should be able to do this semi-automatically by exporting to spreadsheet, edit and import again:
Trond Hasse Lie EPLAN Expert and ex-AutoCAD Electrical user. Autodesk Expert Elite Alumni Ctrl Alt El Please select "Accept Solution" if this post answers your question. 'Likes' won't hurt either. 😉
