Hi I'm looking for help on a excel maybe a macro help.

Question

I really don't know what I am looking for.&nbsp; I know what I need in the end just don't know if or how I can get there.&nbsp; I have a Bill of Material I have exported out of Solidworks into and Excel spreadsheet.&nbsp; I need it indented on column B and C to match the numbering in Column A.&nbsp; See structure as imported attached&nbsp;&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1010131&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; install assy, BIP w/wing lockers-lh&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1010047&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; assy, nut-plate aft outboard doubler&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11.1.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1310120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; nut plate, aft outboard&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1ETC........&nbsp; the numbering sequence can go over as many as 6+ places.&nbsp;TIA Dayton&nbsp;&nbsp;

sergeibaklan · Answer

Not sure about the macro to convert in place, but if transform your data into another place, you may do with formulas. Idea is to calculate number of dots in the cell of first column and add intend (actually add spaces in the front) value in second column. Formula could be like
=REPT(" ",2*LEN($A1)-LEN(SUBSTITUTE($A1,".",""))) &amp; TRIM(B1)

I guess&nbsp;the same could be done with Power Query
&nbsp;
&nbsp;

Forum Discussion

Hi I'm looking for help on a excel maybe a macro help.

Share

Resources