UPC Codes w/LEADING ZEROS & NON-Standardized Lengths &/or Templates! (help!)

50yoExcelDummy · Sep 12, 2011

[FONT=&quot]Hello,

Usually UPC Codes have a certain number of spaces, they are numeric, and may even have some form (a template they follow).
My case is none of the above. Every conceivable combination has been used. See the bottom of this message for an example of just some of the formats I must deal with! As you can see, I can not adhere to the simplest of remedies.
Thank You for your time In Advance! [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I'm trying to help a friend however, I'm not doing so well. They have UPC codes in their POS (Point of Sale) that include EVERYTHING! Text, ISBN Numbers (like a specialized UPC code for books), 1 character, 1 number all the way up to about 20 characters long that include alpha numeric, and dashes. There is NO consistency with it. Thus, I cant make a Template for it that says it must use 20 spaces, or I will not get a match for the POS to call up a price for the item scanned!
Does anyone have an idea?!

My main problem seems to be that I have a number of UPC numbers that start with Zeros. The UPC can be anywhere from 7 digits long to about 13, and the leading zeros can be anywhere from NONE to Five! If I loose the leading Zero(s) - I don't get a match when the POS scans in the UPC code. and looks for the price for the associated item.

I Exported their entire inventory into the only thing that the system would export/output it to, which was a CSV file. After about 8 days of messing things up, I found out the best way to open it - to PRESERVE the leading Zero(s) was to rename the file to a .TXT file Then open it with EXCEL which would then walk me through the steps to ensure I was saving those fields as TEXT fields to keep them precious little placeholders (zero(s)) for me!

My task at hand is this:
I have all the information I need on the Exported file, EXCEPT for two columns which are called SUPPLIER and REORDER No.

Wouldn't ya know... on another file I saved as a .TXT file, I opened in the same manner as described earlier, I have that information along with with the UPC Numbers (in text fields) When trying to do a VLOOKUP My result in the box is "NA"

In any case, Ive determined that I can NOT use the UPC numbers as they are TEXT to to fill in the desired SUPPLIER and REORDER numbers that are on the 2nd sheet!

Can Anyone Pleeeese give me a push in the right direction here.
1. WHAT is the Criteria needed to preform an EFFECTIVE VLOOKUP?
2. WHAT are the Dos/DONTS ... Surely there must be SOME webpage somewhere that describes this!

Here is what Im doing and its break down...
=VLOOKUP(the UPC # from which I am referencing[/FONT][FONT=&quot],[/FONT][FONT=&quot] Highlighting the cells where Excel might get the info from {ie A2:L10435}[/FONT][FONT=&quot],[/FONT][FONT=&quot] the column # {ie b=2, J=10}[/FONT][FONT=&quot],[/FONT][FONT=&quot] and a Zero at the end cuz I want an exact match) ends up looking something like this:
=VLOOKUP(C$2[/FONT][FONT=&quot],[/FONT][FONT=&quot]'REORDER No'!A$2:N$10429[/FONT][FONT=&quot],[/FONT][FONT=&quot]11[/FONT][FONT=&quot],[/FONT][FONT=&quot]0)

I Thank You again for your help!
Gratefully[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Below are a handful of examples of the UPC codes that are in this POS system. As you can see, they have adopted various methods of identification of their products, UPC, ISBN, VENDORS SKUs, Names, etc .. thus making this difficult. Any suggestions you might have would be extremely helpful! [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Again - I thank You!

[/FONT]
<table class="MsoNormalTable" style="width:272.75pt;margin-left:4.65pt;border-collapse:collapse;mso-yfti-tbllook: 1184;mso-padding-alt:0in 5.4pt 0in 5.4pt" border="0" cellpadding="0" cellspacing="0" width="364"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]000[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]0[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]FW2[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:1;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]0003[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]3[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]HTG-1052[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:2;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]00036146[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]36146[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]HTG-116[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:3;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]00036748[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]36748[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]LIFE 5000[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:4;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]0004[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]4[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]U707529029078[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:5;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]0005[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]5[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]46453-7[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:6;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]0653730059918109[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]6.5373E+14[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]992C[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:7;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]08068-80410-2[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119"> [FONT=&quot]A[/FONT][FONT=&quot][/FONT]
</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]0-37387334-4[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:8;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]08068-81117-2[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119"> [FONT=&quot]A101[/FONT][FONT=&quot][/FONT]
</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]0-8307-1839-7[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:9;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]08068-81628-25[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119"> [FONT=&quot]BACON[/FONT][FONT=&quot][/FONT]
</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]0-87983-939-2[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:10;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]08068-83953-22[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119"> [FONT=&quot]BB-6[/FONT][FONT=&quot][/FONT]
</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]0-916035-30-1[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:11;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]099999200249[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]99999200249[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]0-310-92322-0[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:12;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]099999251418[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]99999251418[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]0-373-87336-00[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:13;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]1-56108-004-7[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119"> [FONT=&quot]1/4 LB PATTIES[/FONT][FONT=&quot][/FONT]
</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot]103B[/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:14;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]1-56108-005-5[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119"> [FONT=&quot]1038C[/FONT][FONT=&quot][/FONT]
</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot] [/FONT][FONT=&quot][/FONT]
</td> </tr> <tr style="mso-yfti-irow:15;mso-yfti-lastrow:yes;height:15.0pt"> <td style="width:90.75pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="121"> [FONT=&quot]183448000556[/FONT][FONT=&quot][/FONT]
</td> <td style="width:89.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="119">

[FONT=&quot]1.83448E+11[/FONT][FONT=&quot][/FONT]

</td> <td style="width:93.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:15.0pt" nowrap="nowrap" valign="bottom" width="124"> [FONT=&quot] [/FONT][FONT=&quot][/FONT]
</td> </tr> </tbody></table> [FONT=&quot] [/FONT]
[FONT=&quot] NOTICE how the number in the last row was converted from the left column to the 1.83...+11 when converted to GENERAL (or Numeric) [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]
[/FONT][FONT=&quot]VLOOKUP, UPC, leading zeros, POS[/FONT][FONT=&quot][/FONT]

MartinL · Sep 12, 2011

Hi I work with UPCs myself
You have a lot of text in your post but Im not sure what your table is showing

Can you give me an example in this format

Excel Workbook

A

B

1

UPC (etc)

Outout (what I want to see)

2

3

4

Sheet1

Martin

Il Prete · Aug 8, 2022

MartinL said:
Hi I work with UPCs myself
You have a lot of text in your post but Im not sure what your table is showing

Can you give me an example in this format

Excel Workbook
A B
1 UPC (etc) Outout (what I want to see)
2
3
4
Sheet1

Martin

Good evening Martin, I hope you're doing well, I need to fix a price-book ****, the majority of the codes were turned into 6 or 8 digits and the new POS system the store owner bought only recognize 12 digits UPCs and I don't know what to do, the price-book is 10k+ items long and I'm on a deadline, and since you have experience working with UPCs I'll really appreciate it if you could let me know if there's a tool that will convert the codes into a 12 digits UPC-A legit codes, I'm not tech-savvy and I don't know how to do it myself, my job depends on it.

Peter_SSs · Aug 9, 2022

@Il Prete
I recently referred you to #12 of the Forum Rules. Now I am referring you specifically to #5 of those rules. However, please review all of them while you are there. I have edited your post here to remove the rule breach.

I'm also wondering if you are aware that you are responding to a thread that is almost 11 years old?

UPC Codes w/LEADING ZEROS & NON-Standardized Lengths &/or Templates! (help!)

50yoExcelDummy

New Member

Excel Facts

MartinL

Well-known Member

Il Prete

New Member

Peter_SSs

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

UPC Codes w/LEADING ZEROS & NON-Standardized Lengths &/or Templates! (help!)

50yoExcelDummy

New Member

Excel Facts

MartinL

Well-known Member

Il Prete

New Member

Peter_SSs

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock