Excel: Convert barcode


Before conversion 133600-133601 After the conversion, 133600133601660 Slash and the addition of 660 when be six figures and then Slash and then six figures put 660 Before conversion from 21769-21768 , after conversion 2176821769550 has been deleted "Slash" and the addition of 550 when the five numbers and then "Slash" and then five figures put 550 Before conversion 853 852 after conversion 853 852 600 has been deleted "Slash" and the addition of 600 when the six numbers only without the "Slash" put 600 Before conversion 852 200 after conversion 85220500 has been deleted "Slash" and the addition of 500 when the five numbers without the "Slash" put 500

Before conversion After conversion
133600-133601 133600133601660
137960-137961 137960137961660
129820-129821 129820129821660
137917-137918 137917137918660
21768-21769 2176821769550
106062-106063 106062106063660
85392-85393 8539285393550
128780-128781 128780128781660
136220-136221 136220136221660
126231-126232 126231126232660
85218 85218500
85220 85220500
I wish the solution by the formulas


This question generated 18 answers. To proceed to the answers, click here.

This thread is current as of September 21, 2014.


For more resources for Microsoft Excel