<div>
Will this first letter be always numeric? and how many digits?
</div>


<div>
it will be word sometimes like &quot;Dr.&quot;
</div>


<div>
If you want to drag the formula down all the rows, below formula will take care of blanks:<br />

<pre><code class="code-1 nolinks" id="code-20-42046850-1"><span>=IF(A2=&quot;&quot;,&quot;&quot;,MID(A2,FIND(&quot; &quot;,A2)+1,256))</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
example<br />
<br />
need<br />
<br />
1 Gary Miller<br />
<br />
<br />
to<br />
<br />
Gary Miller
</div>
</div>


example

need

1 Gary Miller


to

Gary Miller

need formula to remove the first word in an excel cell

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.