In this Excel Training video, we’ll show you how to extract substrings using functions in Excel. The functions mentioned in this video are LEFT, RIGHT, MID, and SEARCH. But we also have a bonus tip that uses the SUBSTITUTE function. Let’s get started!
Resources
LEFT Function:
=LEFT(CELL or "text", number)LEFT Examples:
=LEFT(A1, 2)
=LEFT("mystring", 2) [ Returns "my" ]RIGHT Function:
=RIGHT(CELL or "text", number)
RIGHT Examples:
=RIGHT(A1, 6)
=RIGHT("mystring", 6) [ Returns "string" ]MID Function:
=MID(CELL or "text", start position, end position)MID Examples:
=MID(A1, 3, 3)
=MID("mystring", 3, 3) [ Returns "str" ]