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:)
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
