Well, I gotcha why you wanna remove the Unit string. I think you want to add up the qty or mass fields values in excel.
Here you can try a trick in drawing file instead.
add the assembly file in the drawing and then add part list.
edit the part list and select column format... option, format the column to your choice and good to go.
edit style editor for part list to do same sort of work next time.
I hope rest does not need to explain. Enjoy. . . .
Regards
Parminder Jandu
Have a look in the assy model BOM at the CHOOSE COLUMNS icon (looks like a page with a red down arrow) and you will see that there are several QTY options. I use ITEM QTY which is the count of the items and UNIT QTY which is the length of the item or the UOM (200 mm long or Each).
Don't manually overwrite data in the BOM. It will only lead to errors and confusion later on.
I can appreciate that you want to help but the op has probably figured out the answer sometime in the last 6 years.
I can appreciate that we want to help but the op has probably figured out the answer sometime in the last 6 years.
nevertheless nobody will return unanswer on this thread as I had. . . .
Regards,
Parminder Jandu