In this article we are going to learn what the sub string functions are and how we can get sub-string in Microsoft Excel.
Sometimes, we may need to extract some text from a string. And to do so there are so many sub-string excel formula, from which we will use the RIGHT, LEFT, SEARCH, LEN, FIND, ISNUMBER and IF formulas in Microsoft Excel.
To extract the excel substring from a string follow the below given steps:-
Example 1: We have a list of names in Column “A” and we need to extract the First name from the list.
Let’s take an another example to extract the sub strings from the Left
Example 2:- We have list of email ids from which we need to extra only the name which is all the text before the “@” symbol.
This means that the “@” symbol is located at the 5 position in the text string, starting from the left-most character.
To separate the name from the list by using the “Left” function along with “Search” function follow the below mentioned steps:-
Let’s take an another example to extract the sub strings from the Middle
Example 3: We have a list of Names in Column “A” and we need to pick the middle name from the list.
To pick the Middle name from the list, we will use the MID function along with the SEARCH function.
This is the way you can extract the sub string from a string by using the above mentioned formulas in Microsoft Excel.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.