Forum Discussion
tpulagura
Aug 20, 2021Copper Contributor
Multi Level Indentured Bill of material format in excel.
Hello,
I am trying to sort out my indentured BOM from solid works see Figure 1 to looks like See Figure 2, Is it possible in excel? if yes share me your code/formula ? Thanks in advance:)
Regards,
Thiru
1 Reply
Sort By
- artup720Copper ContributorHi,
Try clean trim function. If these are leading spaces it will be removed. If this is some other char the copy one of the chars you want to remove and use substitute function to replace it to "".
Regards
Artur