<div>
This finds the first string between double quotes:<br />

<pre><code id="code-20-39543803-1">Function ExtractTitle(strText As String) As String
    Dim strParts() As String
    
    strParts = Split(&quot;x&quot; &amp; strText, &quot;&quot;&quot;&quot;) '&quot;x&quot; copes with case of &quot; in position 1
    ExtractTitle = strParts(1)
End Function</code></pre>
</div>


This finds the first string between double quotes:


Function ExtractTitle(strText As String) As String
    Dim strParts() As String
    
    strParts = Split("x" & strText, """") '"x" copes with case of " in position 1
    ExtractTitle = strParts(1)
End Function

<div>
Why would you want to use a user-defined function for this?
</div>


Why would you want to use a user-defined function for this?

<div>
<div class="content wysiwyg-content">
I use a formula (see below) to extract a string that is contained between double/single quotes.<br />
<br />
=MID(A1,FIND(&quot;)&quot;,A1,1)+2,4<wbr />5)<br />
<br />
How to I change this formula into a UDF?<br />
<br />
Function &quot;ExtractTitle&quot;<br />
...<br />
...<br />
End Function<br />
<br />
Btw, the currently formula includes the &quot;&quot;&nbsp;and ' ' upon extraction. &nbsp; I really only need the text in between. &nbsp; Any suggestions as to how the double/single quotes can be removed from the output?<br />
<br />
EEH
</div>
</div>


I use a formula (see below) to extract a string that is contained between double/single quotes.

=MID(A1,FIND(")",A1,1)+2,45)

How to I change this formula into a UDF?

Function "ExtractTitle"
...
...
End Function

Btw, the currently formula includes the "" and ' ' upon extraction.   I really only need the text in between.   Any suggestions as to how the double/single quotes can be removed from the output?

EEH

How to turn formula into UDF?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.