LEFT RIGHT, LEFT RIGHT LEFT!
- Enya Low
- Aug 9, 2017
- 1 min read
LEFT and RIGHT functions are used to extract the FIRST (left) and LAST (right) characters in a cell.
Excel Formula: =LEFT(text, [num_chars]) ;
=RIGHT(text, [num_chars])
Formula Made Easy
Example
I have a list of Students, including their Student ID. However, I want to extract the Student ID from the names.
I would use the LEFT formula instead of the RIGHT as there is a consistent number of characters (3) to extract from the left-hand side compared to the right.
To extract the Student IDs, my formula will be:
=LEFT(A2,3)
Remember: it's characters, not words so it includes spaces.
'Right left' image sourced from:
Comments