#### dab1477

##### Board Regular

- Joined
- Jul 30, 2002

- Messages
- 65

The formula works well when I have a single "/" in column J (Product Description). It returns the correct value in Column T. My issue is when there are mulitple "/" in Cell J (Product Description). I want the formula to read only the NUMERIC digits to the left of the "/" (i.e. 12/1.5; I want to use 12 in the formula). I want to ignore the alpha to the left or right of the "/". (I.e. ignore RED/YELLOW or YELLOW/PURPLE). How do I make this work? Stumped!!

Thanks in advance for any direction given.

Col I J K L M NOPQ R S T

(NOPQ = Blank)

Ordered Product SKU Ordered Comm Completed Pack Single

Quantity Description Netweight Variety Order (x) on Line Units

800 10/5 lb. Ahold Russet USA (40034) R400 40000 POT RUS 3 8000

200 10/5 lb. Ahold Red USA (40015) RED284 10000 POT RED 2 2000

400 5/10 lb. GV Russet USA (279636) R442 20000 POT RUS 5 2000

200 10/5 lb. Ahold White USA (40002) W347 10000 POT WHT 5 2000

54 Fingerlings . B Size 12/1.5lb Steam Carton . Side Delights Steamables Steamable US #1 . F186 972 POT FIN 7 648

54 Medley RED/YELLOW/PURPLE C Size 12/1.5lb Steam Carton . Side Delights Steamables Poly Roll US #1 . MDLY114 972 POT MDLY 6 #VALUE!

12 Mix . C Size 2 Var* 6Packs/ 1lb Side Delight Roastable Carton Misc. Side Delight Roastable Roastable Tray US #1 . MIX153 144 POT MIX 5 #VALUE!