Gramlights
New Member
- Joined
- Oct 6, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Looking for a formula to extract text from between the 2nd and 3rd dash ("-").
Example: Create a formula to extract the word "pear"
apple-orange-pear-guava
But ONLY using the functions of MID, FIND, LEFT, RIGHT.
Note:
I'm able to come up with a formula to extract the word between the 1st and 2nd dash ("orange"), however I'm not quite sure how to manipulate the formula to achieve other nth extractions.
=MID(A1,FIND("-",A1,1)+1,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1)-1)
Thank you so much all!
Example: Create a formula to extract the word "pear"
apple-orange-pear-guava
But ONLY using the functions of MID, FIND, LEFT, RIGHT.
Note:
I'm able to come up with a formula to extract the word between the 1st and 2nd dash ("orange"), however I'm not quite sure how to manipulate the formula to achieve other nth extractions.
=MID(A1,FIND("-",A1,1)+1,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1)-1)
Thank you so much all!