<div>
Try this formula, where cell A1 contains your text.<br />
<br />
=LEN(TRIM(MID(A1,FIND(&quot;|&quot;,<wbr /> SUBSTITUTE(A1, &quot;&nbsp;&quot;, &quot;|&quot;, 1)),FIND(&quot; &quot;, SUBSTITUTE(A1, &quot;&nbsp;&quot;, &quot;|&quot;, 1))-FIND(&quot;|&quot;, SUBSTITUTE(A1, &quot;&nbsp;&quot;, &quot;|&quot;, 1)))))
</div>


<div>
Try this and change any nth word in (2-1):<br />

<pre><code class="code-1 nolinks" id="code-20-42046907-1"><span>=IF(A1=&quot;&quot;,&quot;&quot;,LEN(TRIM(MID(SUBSTITUTE(A1,&quot; &quot;,REPT(&quot; &quot;,LEN(A1))), (2-1)*LEN(A1)+1, LEN(A1)))))</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
example<br />
<br />
A J Schreiber<br />
<br />
result = 1, for the letter J which is 2nd workd
</div>
</div>


example

A J Schreiber

result = 1, for the letter J which is 2nd workd

need formula to  count the number of letters in the 2nd word of excel value

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.