Extracting Characters from a Cell or String, from LEFT to right

What you are about to be challenged or learn about, has MANY uses. This business case will come VERY handy if you work with POS, Sales Data

Many times, when your receive your sales report, UPC code not necessarily always match, when trying to referring to other tables.

Main reason sometimes, is due to the CHECK digit.

This moderate challenge, will make you extract the UPC code without the CHECK digit


Click the image below to download the macro free Excel file and start your Challenge


RCUBE Solutions - Medium 01 LEFT combination formula