ExcelHeroThe LEFT function
Takes characters from the start of text.
In German Excel: LINKS
How to write it
=LEFT(text, [num_chars])- text
- The text.
- num_chars
- How many characters.
💡 Combine with FIND to cut up to a symbol.
Try it
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).