LEFT, RIGHT, MID extraction in Excel - Dashboard Guide

Dashboard Mode - LEFT, RIGHT, MID extraction

Dashboard Goal

Extract parts of product codes to analyze product categories, regions, and item numbers separately.

Sample Data

Product Code	Full Code Description
US12345A	United States, Item 12345, Type A
EU98765B	Europe, Item 98765, Type B
AS54321C	Asia, Item 54321, Type C
AF67890D	Africa, Item 67890, Type D
SA11223E	South America, Item 11223, Type E

Dashboard Components

• KPI Card 1: Region Code
  Formula: =LEFT(A2,2)
  Extracts the first 2 letters representing the region from the product code.
• KPI Card 2: Item Number
  Formula: =MID(A2,3,5)
  Extracts 5 characters starting from the 3rd character, representing the item number.
• KPI Card 3: Product Type
  Formula: =RIGHT(A2,1)
  Extracts the last character representing the product type.
• Summary Table
  Shows extracted parts side by side for easy comparison.

Dashboard Layout

+----------------+----------------+----------------+------------------+
| Region Code    | Item Number    | Product Type   | Summary Table    |
| (LEFT formula) | (MID formula)  | (RIGHT formula)| (All extracted)  |
+----------------+----------------+----------------+------------------+

Interactivity

User can filter product codes by region code using a dropdown filter. When a region is selected, all KPI cards and the summary table update to show only product codes from that region.

Self Check

If you add a filter to show only product codes starting with 'EU', which components update and what values do they show?

• Region Code KPI: Shows 'EU' only.
• Item Number KPI: Shows item numbers like '98765'.
• Product Type KPI: Shows product types like 'B'.
• Summary Table: Shows only rows with product codes starting with 'EU'.

Key Result

Dashboard extracts and displays region, item number, and product type from product codes using LEFT, MID, and RIGHT formulas.