Extract specific words/strings from a cell

try: =IFERROR(TRIM(MID(A1,FIND("-",A1)+1,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1)-1)),"Check characters")

---

If the basic problem is solved
- it's always a good practice to show respect to the person(s) who have helped you
- is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you) and then
- mark the thread as SOLVED (top right corner over your first post - Thread Tools). This is important for all of us,
If you did it - ignore this post, if not - just do it
Thanks

---

try in C1 (if previous formula was in B1)

Formula:

Please Login or Register  to view this content.

I assume there is always something like "-" around the text what you want to extract

or
A1 your text
B1 this formula

Formula:

Please Login or Register  to view this content.

drag it from B1 to C1 and next drag both down