How to find text within a parentheses
Have you ever wondered how to find text within a parentheses, then this video is for you.
I have used mid and search function to extract the text within a parentheses.
1. Identify the starting position of the parentheses and along with this identify the position of the first character within parentheses
2. Identity the closing position of the parentheses as it marks the end of your text
3. Deduct the ending position from the starting position, which will give you the number of characters to be extracted.
4. Combine all the three steps formula to extract the text within parentheses.
#excel #mid #search #identifytext
Keep Watching,Keep learning.