ExcelHero

Today’s challenge

Saturday, October 31. One task, a minute or two. Solve it to keep your streak.

Take the 2-letter category from the start of the code in C2.

A
B
C
D
1
Full name
City
Code
Category
2
maya lopez
berlin
TS-1042-BLU
3
LEO KING
paris
HD-0077-RED
4
sam o’neil
Rome
MG-3150-GRN

=LEFT(text, how many).