Get string between parts <p>I am having a string:</p> <pre><code>c(\\", \"Â \", \"Â \", \"\", \"\", \"Object:\", \"\", \"\", NA, \"vlg. numb 2\", \"\", NA, NA, NA, NA, \"This:Â \", NA, \"Date\r\n(21.03.1961)\", \"K..\r\nRom (28.04.2012)\", NA, NA, \"test.test@yahoo.de\", NA, \"Italy, Rome\", NA, \"UP,Â Ã–\", \"BP,Â \", NA, NA, NA, NA, NA)" </code></pre> <p>I would like to get the string <code>numb 2</code>, which is between <code>vlg.numb 2\"</code></p> <p>I tried:</p> <pre><code>=MID(A18;FIND("vlg.";A18;1)+7;FIND("/object";A18;1)-FIND("\";A18;1)-8) </code></pre> <p>However, I only get <code>#VALUE</code> back.</p> <p>Any suggestions what I am doing wrong?</p>