Delete everything BEFORE and AFTER a certain string of characters, including string itself

assuming the whole string is stored in Cell B4, try the following formula in the cell where you desire the result:

Formula:

=MID(B4,FIND("""",B4,1)+1,FIND("""",B4,FIND("""",B4,1)+1)-(FIND("""",B4,1)+1))