Convert barcode

shimaa01234

Active Member
Joined
Jun 24, 2014
Messages
446
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 conversionAfter conversion
133600-133601133600133601660
137960-137961137960137961660
129820-129821129820129821660
137917-137918137917137918660
21768-217692176821769550
106062-106063106062106063660
85392-853938539285393550
128780-128781128780128781660
136220-136221136220136221660
126231-126232126231126232660
8521885218500
8522085220500

<colgroup><col><col></colgroup><tbody>
</tbody>
I wish the solution by the formulas
 
Thank you for the wonderful solutions
Thank you very much Mr. "martindwilson"
Thank you very much Mr. "Br0ck"
 
Upvote 0

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Wow, Mister "Rick"
This is a wonderful solution and new
Thank you and genius
I love such compositions in the formulas
 
Upvote 0
Mister "Rick"
A condition has not been achieved
It is "if the numbers without a single" Dash "and number 6 is added to the number 600
If the 5 500 is added as it exists in the latter condition
85218485218600
85220085220500

<colgroup><col><col></colgroup><tbody>
</tbody>
 
Upvote 0
Mister "Rick"
A condition has not been achieved
It is "if the numbers without a single" Dash "and number 6 is added to the number 600
If the 5 500 is added as it exists in the latter condition
85218485218600
852200
85220500

<tbody>
</tbody>
Please explain why 852200 (a six-digit number) should be converted to 85220500 and not 852200600.
 
Upvote 0
Yes Mister "Rick" You're right about the number "852 200"
It is "85 220" will be added to the 500 because it has 5 digits
As this number "852184" should be "852184600 "
Because 6 digits must add his 600
Thank you very much Mr. "Rick"
 
Last edited:
Upvote 0
Yes Mister "Rick" You're right about the number "852 200"
It is "85 220" will be added to the 500 because it has 5 digits
As this number "852184" should be "852184600 "
Because 6 digits must add his 600

Okay, then give this formula a try...

=IF(COUNTIF(A1,"*-*"),SUBSTITUTE(A1,"-","")&550+110*(FIND("-",A1)=7),A1&100*LEN(A1))
 
Upvote 0

Forum statistics

Threads
1,215,063
Messages
6,122,935
Members
449,094
Latest member
teemeren

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top