How to get Substrings in Excel with Functions

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!


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" ]

John Gleave

John Gleave has been a researcher, content writer, and senior editor at Business Tech Planet since 2022. John was formerly a data analyst and web designer with expertise in several programming languages, such as JavaScript, JQuery, PHP, CSS, SQL, and more! With a passion for writing and technology, he has now focused his skills on crafting tech guides for BTP. You can connect with John on LinkedIn.

Recent Posts