Hi, I'm looking for some VBA that will help me extract product weight information from a list of products.

Here's an example list:

SHARWOODS BENGALHOT MANGO CHUTNEY 360G
CRUSTY WHITE SLICED SPLIT TIN 800G
MILD PIQUANTE PEPPERS 375G - SPECIAL OFFER
PAROZONE BLEACH CITRUS 750ML
ROBINSONS SPECIAL-R-ORANGEDRINK 2LTR
SMIRNOFF RED LABEL VODKA 70CL - SPECIAL OFFER
HELLMANNS REAL MAYONNAISE 400G

The weights are not always at the end of the description.

Hope you can help!!