Forum Discussion
Solved
Excel Forumla to Extract data between first and last occurrance of specific charactersin a cell?
Excel Forumla to Extract data between first and last occurrance of specific character I need an Excel Forumla that will extract and return the data between first and last occurrance of the _ (und...
=MID(A1,FIND("_",A1)+1,FIND("|",SUBSTITUTE(A1,"_","|",(LEN(A1)-LEN(SUBSTITUTE(A1,"_","")))/LEN("_")))-1-FIND("_",A1))Maybe with this formula.
=MID(A1,FIND("_",A1)+1,FIND("|",SUBSTITUTE(A1,"_","|",(LEN(A1)-LEN(SUBSTITUTE(A1,"_","")))/LEN("_")))-1-FIND("_",A1))Maybe with this formula.
Thank you for kindly helping.
It works perfectly and I would never have been able to work out something that complex.
You have really helped me.
