Multi Level Indentured Bill of material format in excel.

%3CLINGO-SUB%20id%3D%22lingo-sub-2670634%22%20slang%3D%22en-US%22%3EMulti%20Level%20Indentured%20Bill%20of%20material%20format%20in%20excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2670634%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20sort%20out%20my%20indentured%20BOM%20from%20solid%20works%20see%20Figure%201%20to%20looks%20like%20See%20Figure%202%2C%20Is%20it%20possible%20in%20excel%3F%20if%20yes%20share%20me%20your%20code%2Fformula%20%3F%20Thanks%20in%20advance%3A)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EThiru%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2670634%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2671147%22%20slang%3D%22en-US%22%3ERe%3A%20Multi%20Level%20Indentured%20Bill%20of%20material%20format%20in%20excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2671147%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3ETry%20clean%20trim%20function.%20If%20these%20are%20leading%20spaces%20it%20will%20be%20removed.%20If%20this%20is%20some%20other%20char%20the%20copy%20one%20of%20the%20chars%20you%20want%20to%20remove%20and%20use%20substitute%20function%20to%20replace%20it%20to%20%22%22.%3CBR%20%2F%3ERegards%3CBR%20%2F%3EArtur%3C%2FLINGO-BODY%3E
Occasional Visitor

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
Hi,
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