Spreadsheet: 114718d1310458420-excel-2007-trim-formula-sample
Sheet: Sheet1

Item Code | Item Description | Packing | Exp. Date | Qty. (CSE) | PHYS
CGIZARD001 | 20X450 GM  [NAME]. | 20x45 | 2011-07-13 00:00:00 | 3 | NIL | [NAME] using =trim(a2) and the result is only CGIZARD001 , but this time is not working
PRO051 | [NAME] | 450GX | 2011-07-15 00:00:00 | 1 | 1
CGIZARD001 | 20X450 GM  [NAME]. | 20x45 | 2011-07-22 00:00:00 | 3 | NIL
CGIZARD001 | 20X450 GM  [NAME]. | 20x45 | 2011-07-28 00:00:00 | 1 | NIL
VEG020 | 20X400GM  OKHRA MISR | 20X40 | 2011-07-31 00:00:00 | 1 | 1
VEG022 | 20X400GMS  SPINACH MISR | 20X40 | 2011-07-31 00:00:00 | 3 | NIL
BFCUBE003 | 18 KG  BF CUBE AL-AFIA | 20X90 | 2011-08-01 00:00:00 | 11 | 2
BUTR001 | [NAME] CREAM BUTTER U/S-25KG-PARAS | 1X25K | 2011-08-01 00:00:00 | 97.5 | 97
BUTR001 | [NAME] CREAM BUTTER U/S-25KG-PARAS | 1X25K | 2011-08-01 00:00:00 | 198 | 198
BFCUBE002 | 18KG BEEF CUBES AL-FIZA | 20X90 | 2011-08-04 00:00:00 | 21 | NIL
CLIVER007 | 20X450 GM  BR CHKN LIVER CANCO | 20X45 | 2011-08-07 00:00:00 | 4 | NIL
PRO058 | 340GX4X6  BR CHKN FRANK G.PHEONIX-PROMO | 340GX | 2011-08-15 00:00:00 | 3 | 4
CLEG003 | 15 KG US B/S WHOLE LEGS TYSON | 15 KG | 2011-08-19 00:00:00 | 3 | NIL
BFCUT009 | BEEF SILVERSIDE BRZ [NAME] |  | 2011-08-20 00:00:00 | 149 | 149
BTOPS001 | 20 KG BF TOPSIDE ( 5 STAR) | 20 KG | 2011-08-30 00:00:00 | 46 | 14
CHKN113 | 1600X08  BR CHKN SEARA | 1600X | 2011-08-30 00:00:00 | 1 | 1
BFCUBE003 | 18 KG  BF CUBE AL-AFIA | 20X90 | 2011-08-31 00:00:00 | 12 | 12
BFMINCE007 | 18 KG  BEEF MINCE ALAHMED | 20X90 | 2011-08-31 00:00:00 | 235 | 235
BFOFFAL001 | BEEF TOPSIDE MINERVA |  | 2011-08-31 00:00:00 | 33 | 33
BFOFFAL004 | BEEF EYEROUND MINERVA |  | 2011-08-31 00:00:00 | 49 | 49
BUTR001 | [NAME] CREAM BUTTER U/S-25KG-PARAS | 1X25K | 2011-08-31 00:00:00 | 69 | 69
CDSTICK001 | 10X900GM  [NAME]  NAT | 10X90 | 2011-08-31 00:00:00 | 65 | 65
CHKN025 | 1300X10 ARG CHKN BECAR | 1300X | 2011-08-31 00:00:00 | 2 | 2
CHKN066 | 1000X10  ARG CHKN BECAR | 1000X | 2011-08-31 00:00:00 | 20 | 20
CHKN067 | 1100X10  ARG CHKN BECAR | 1100X | 2011-08-31 00:00:00 | 2.5 | 2.5
CHKN131 | 1700X10  DN CHKN PADBORG | 1700X | 2011-08-31 00:00:00 | 7 | 2
CHKN134 | 1900X09 DN CHKN PADBORG | 1900X | 2011-08-31 00:00:00 | 3.22 | 3
CHKN141 | 1400X10 BR CHKN SUANGO | 1400X | 2011-08-31 00:00:00 | 3 | 3
CWING010 | 10.80KG  BR CHKN WINGS SEARA | 12X09 | 2011-08-31 00:00:00 | 22 | 22
VLCUBE005 | 18 KG VEAL CUBES PRIMO | 20X90 | 2011-08-31 00:00:00 | 27 | 27
BFCUBE003 | 18 KG  BF CUBE AL-AFIA | 20X90 | 2011-09-01 00:00:00 | 5 | 5
BFCUBE009 | 18 KG  BF CUBE AL-QURESH | 20X90 | 2011-09-01 00:00:00 | 16 | 16
BFMINCE003 | 18 KG  BEEF MINCE INDIAN AMBER | 20X90 | 2011-09-01 00:00:00 | 100 | 100
CFRANK001 | 24X340 GM  BR CHKN FRANK AURORA | 24X34 | 2011-09-01 00:00:00 | 1278.5 | 1278
CFRANK002 | 24X340 GM  [NAME] | 24X34 | 2011-09-01 00:00:00 | 430 | 430
CFRANK007 | 24X340 GM  BR CHKN FRANK SEARA | 24x34 | 2011-09-01 00:00:00 | 10 | 10
CLEGQ001 | 10 KG  BR CHKN Q.LEGS FRANGO  BOM | 10 KG | 2011-09-01 00:00:00 | 3 | 3
PRO051 | [NAME] | 450GX | 2011-09-01 00:00:00 | 7 | 7
VEG043 | 4X2.5KG SPINACH TOMEX | 4X2.5 | 2011-09-01 00:00:00 | 174 | 174
CFRANK007 | 24X340 GM  BR CHKN FRANK SEARA | 24x34 | 2011-09-02 00:00:00 | 4 | 4
CFRANK007 | 24X340 GM  BR CHKN FRANK SEARA | 24x34 | 2011-09-02 00:00:00 | 2 | 2
CFRANK007 | 24X340 GM  BR CHKN FRANK SEARA | 24x34 | 2011-09-02 00:00:00 | 1 | 1
MTTN006 | LAMB CCS INDIAN ALLANA | NON-S | 2011-09-05 00:00:00 | 1 | 1
MTTN006 | LAMB CCS INDIAN ALLANA | NON-S | 2011-09-05 00:00:00 | 9 | 9
MTTN002 | MTTN SIX WAY CUT AUST -ARARAT | NON-S | 2011-09-06 00:00:00 | 400 | 400
BFOFFAL005 | BEEF [NAME] |  | 2011-09-07 00:00:00 | 1 | 1
BFOFFAL005 | BEEF [NAME] |  | 2011-09-08 00:00:00 | 9 | 9
CWING003 | 15 KG BR CHKN WINGS TYSON | 15 KG | 2011-09-08 00:00:00 | 1 | 1
[NAME] | 15KG BRZ CHKN WINGS COSSISA | 15 kg | 2011-09-09 00:00:00 | 2 | 2
MTTN002 | MTTN SIX WAY CUT AUST -ARARAT | NON-S | 2011-09-13 00:00:00 | 5 | 5
MTTN002 | MTTN SIX WAY CUT AUST -ARARAT | NON-S | 2011-09-15 00:00:00 | 10 | 10
CLIVER004 | 20X450 GM  BR CHKN LIVER NAT | 20X45 | 2011-09-19 00:00:00 | 2 | 2
BFOFFAL004 | BEEF EYEROUND MINERVA |  | 2011-09-20 00:00:00 | 86 | 86
CWING003 | 15 KG BR CHKN WINGS TYSON | 15 KG | 2011-09-23 00:00:00 | 8 | 8
MTTN002 | MTTN SIX WAY CUT AUST -ARARAT | NON-S | 2011-09-23 00:00:00 | 99 | 99
CLEGQ002 | 15 KG  US CHKN Q.LEGS AJC | 15 KG | 2011-09-29 00:00:00 | 6 | 6
BTLOIN004 | 20 KG  BEEF TLOIN AMBER | 20KG | 2011-09-30 00:00:00 | 1 | 1
BTOPS001 | 20 KG BF TOPSIDE ( 5 STAR) | 20 KG | 2011-09-30 00:00:00 | 28 | 28
BTOPS001 | 20 KG BF TOPSIDE ( 5 STAR) | 20 KG | 2011-09-30 00:00:00 | 80 | 80
CHKN217 | 1300X10 BR CHKN SEARA | 1300X | 2011-09-30 00:00:00 | 2 | 2
CWING003 | 15 KG BR CHKN WINGS TYSON | 15 KG | 2011-09-30 00:00:00 | 1 | 1
CWING003 | 15 KG BR CHKN WINGS TYSON | 15 KG | 2011-09-30 00:00:00 | 1 | 1
MILK001 | WHOLE MILK POWDER INSTANT - PARAS |  | 2011-09-30 00:00:00 | 6 | 6
MTTN002 | MTTN SIX WAY CUT AUST -ARARAT | NON-S | 2011-09-30 00:00:00 | 167 | 167
BFCUBE003 | 18 KG  BF CUBE AL-AFIA | 20X90 | 2011-10-01 00:00:00 | 750 | 750
MCUBE002 | 18 KG  MTTN CUBE IND EATCO | 18 KG | 2011-10-02 00:00:00 | 1 | 1
CLEGQ005 | 15 KG  US CHKN Q.LEGS TYSON | 15 KG | 2011-10-04 00:00:00 | 2 | 2
LEMON001 | 12X1LTR LEMON JUICE EGE YLDIZI | 12X1L | 2011-10-04 00:00:00 | 10 | 10
LEMON001 | 12X1LTR LEMON JUICE EGE YLDIZI | 12X1L | 2011-10-04 00:00:00 | 27.92 | 27.92
LEMON002 | 20X500ML LEMON JUICE EGE YLDIZI | 20X50 | 2011-10-04 00:00:00 | 41.95 | 41.95
CLEG005 | 6X2KG BR W/LEG B/L SUPER FRANGO | 6X2 K | 2011-10-08 00:00:00 | 5 | 5
CLEGQ005 | 15 KG  US CHKN Q.LEGS TYSON | 15 KG | 2011-10-08 00:00:00 | 8 | 8
CDSTICK001 | 10X900GM  [NAME]  NAT | 10X90 | 2011-10-13 00:00:00 | 13 | 13
CGIZARD001 | 20X450 GM  [NAME]. | 20x45 | 2011-10-13 00:00:00 | 131 | 131
PRO0124 | 400GX2X9 JOR CH FILLET AL MARAAI PROMO | 400Gx | 2011-10-14 00:00:00 | 39 | 39
PRO0125 | 200GX2X24 JOR BEEF BURGER AL MARAAI PROMO | [NAME] | 2011-10-14 00:00:00 | 45.59 | 45.59
CDSTICK001 | 10X900GM  [NAME]  NAT | 10X90 | 2011-10-17 00:00:00 | 10 | 10
VEG034 | 16KG  GUAVA PULP INDIAN | 16 KG | 2011-10-17 00:00:00 | 33 | 33
CLIVER004 | 20X450 GM  BR CHKN LIVER NAT | 20X45 | 2011-10-19 00:00:00 | 6 | 6
CGIZARD006 | 32X500 GM  BR CHKN GIZARD MINUANO | 32X50 | 2011-10-23 00:00:00 | 6 | 6
CHKN036 | 1100X10  BR CHKN NAT. | 1100X | 2011-10-29 00:00:00 | 14.7 | 14.7
CHKN037 | 1200X10  BR CHKN NAT. | 1200X | 2011-10-29 00:00:00 | 845 | 845
CDSTICK003 | 12X900GM  BR DSTICK BIG-TYSON | 12X90 | 2011-10-30 00:00:00 | 11 | 11
CLEGQ005 | 15 KG  US CHKN Q.LEGS TYSON | 15 KG | 2011-10-30 00:00:00 | 3 | 3
CLEGQ005 | 15 KG  US CHKN Q.LEGS TYSON | 15 KG | 2011-10-30 00:00:00 | 2 | 2
CLEGQ005 | 15 KG  US CHKN Q.LEGS TYSON | 15 KG | 2011-10-30 00:00:00 | 16 | 16
BTLOIN005 | 18 KG  BF TLOIN AL-AFIA | 18 KG | 2011-10-31 00:00:00 | 2 | 2
CHEES001 | 40X250GM TUR CHEESE HALOOUMI GRN ISLAND | 40x25 | 2011-10-31 00:00:00 | 7 | 7
CHEES001 | 40X250GM TUR CHEESE HALOOUMI GRN ISLAND | 40x25 | 2011-10-31 00:00:00 | 99 | 99
CHKN023 | 1300X10  BR CHKN PENA BRNCA | 1300X | 2011-10-31 00:00:00 | 3 | 3
CHKN036 | 1100X10  BR CHKN NAT. | 1100X | 2011-10-31 00:00:00 | 498 | 498
CHKN063 | 1700X08  BR CHKN SEARA/SANTA | 1700X | 2011-10-31 00:00:00 | 1 | 1
CHKN113 | 1600X08  BR CHKN SEARA | 1600X | 2011-10-31 00:00:00 | 664 | 664
CHKN113 | 1600X08  BR CHKN SEARA | 1600X | 2011-10-31 00:00:00 | 411 | 411
CHKN113 | 1600X08  BR CHKN SEARA | 1600X | 2011-10-31 00:00:00 | 20 | 20
CHKN128 | 1500X10  BR CHKN PENA BRANCA | 1500X | 2011-10-31 00:00:00 | 1 | 1
CHKN134 | 1900X09 DN CHKN PADBORG | 1900X | 2011-10-31 00:00:00 | 5 | 5
CHKN135 | 0800X10 ARG CHKN TYSON | 0800X | 2011-10-31 00:00:00 | 92 | 92
CHKN168 | 1400X10 BR CHKN ZEINA | 1400X | 2011-10-31 00:00:00 | 110 | 110
CHKN189 | 1700X10  BR CHKN WESTFALIA | 1700X | 2011-10-31 00:00:00 | 4 | 4
CHKN190 | 1800X08  BR CHKN WESTFALIA | 1800X | 2011-10-31 00:00:00 | 312 | 312
CHKN191 | 1900X08  BR CHKN WESTFALIA | 1900X | 2011-10-31 00:00:00 | 26 | 26
CHKN191 | 1900X08  BR CHKN WESTFALIA | 1900X | 2011-10-31 00:00:00 | 120 | 120
CHKN193 | 2000X08  BR CHKN WESTFALIA | 2000X | 2011-10-31 00:00:00 | 249 | 249
CHKN219 | 1500X8 BR CHKN SEARA | 1500X | 2011-10-31 00:00:00 | 40 | 40
CHKN220 | 1700X8 BR CHKN SEARA | 1700X | 2011-10-31 00:00:00 | 536 | 536
CHKN220 | 1700X8 BR CHKN SEARA | 1700X | 2011-10-31 00:00:00 | 10 | 10
CLEGQ009 | 15 KG  US CHKN Q.LEGS  MOUNT.FARMS | BULK | 2011-10-31 00:00:00 | 1 | 1
CLEGQ009 | 15 KG  US CHKN Q.LEGS  MOUNT.FARMS | BULK | 2011-10-31 00:00:00 | 2 | 2
VEG033 | 16KG  MANGO PULP INDIAN | 16 KG | 2011-10-31 00:00:00 | 327 | 327
VEG034 | 16KG  GUAVA PULP INDIAN | 16 KG | 2011-10-31 00:00:00 | 161 | 161