I am generating my BOMs using the indented feature. Which is needed to generate my detailed cut lists. As the BOM progresses it adds spaces in front of each child part. By the time I get to the end of the BOM there are 10-15 spaces added.
I export this to excel to generate my parts list. The issue here is I have to go through and manually delete all of the spaces.
Is there a simple option to remove the indentation of the subassembly features?
In Excel you can use the TRIM() function to remove leading and trailing blank characters from text. Pick an empty column on the right, enter =trim(cell with part number in it), copy this down for the length of your BOM. Then if you want you can copy this column and use Paste Special -> Values to paste these trimmed values back into the original part number column.