← All exercises

LEFT — Product code

Extract a product code

Pull apart a structured product reference into its category, number and full code using LEFT, RIGHT, MID, LEN and & — 6 guided steps.

=LEFT( cell , num_chars )

1 / 6

Extract the type (first 3 letters of A2)

=RIGHT( cell , num_chars )

2 / 6

Extract the sequential number (last 3 characters of A2)

=LEN( cell )

3 / 6

Count the number of characters in A2

=MID( cell , start , num_chars )

4 / 6

Extract the family code (3 letters in the middle, position 5)

=LEFT(…)&"-"&RIGHT(…)

5 / 6

Rebuild a short code: type + number

=LEFT( cell , 1 )

6 / 6

Extract the first letter of the description B2

Your score is

0%