Task 1 of 4
In B2:B5, extract the country code: the first 2 characters of the SKU.
Lesson theory
LEFT(text, n)returns the first n characters,RIGHTthe last n;MID(text, start, n)returns n characters from the middle;LEN(text)is the length;FIND("@", text)gives the position of a character (case-sensitive), andSEARCHdoes the same without regard to case.
A username from an email address:
=LEFT(F2,FIND("@",F2)-1) returns everything before the "@".Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.