Goal: Extract specific characters from the string. LEFT: Starts at the beginning. RIGHT: Starts at the end.
(Result appears here)
Ready...
💻 Formula Structure
=LEFT(text, [num_chars])
1. Text: The string to extract from.
2. Num Chars: How many to take from the left (Default is 1).
=RIGHT(text, [num_chars])
1. Text: The string to extract from.
2. Num Chars: How many to take from the right.
-- Select a function...
...
Extracted Text:
-
⚠️ Common Pitfalls
🚫 Numbers become Text
The result of LEFT/RIGHT is always Text. If you extract "100", it is text "100", not number 100. Math might fail unless you convert it (e.g. using VALUE or --).
🚫 Spaces Count
Spaces are characters too! RIGHT("A B", 2) returns " B" (Space + B), not "AB".