<div>
This seems to work: <br />

<pre><code id="code-20-41787111-1">=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&amp;&quot;0123456789&quot;))+3)&amp;PROPER(MID(A1,MAX(FIND({0,1,2,3,4,5,6,7,8,9},&quot;0123456789&quot;&amp;A1,1))+10,99999))</code></pre>
<br />
My result:<br />

<pre><code id="code-20-41787111-2">ONE CELL:    1463 Asphalt Works: Op By Contr-Perm &amp; Drvr</code></pre>
<br />
Swap all the occurrences of A1 in the formula for the cell you're wanting to target.
</div>


This seems to work:


=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+3)&PROPER(MID(A1,MAX(FIND({0,1,2,3,4,5,6,7,8,9},"0123456789"&A1,1))+10,99999))


My result:


ONE CELL:    1463 Asphalt Works: Op By Contr-Perm & Drvr


Swap all the occurrences of A1 in the formula for the cell you're wanting to target.

<div>
Haha I must be half asleep in my lunch hour... I included ONE CELL as part of the data... oops
</div>


Haha I must be half asleep in my lunch hour... I included ONE CELL as part of the data... oops

<div>
<div class="content wysiwyg-content">
Data Sample<br />
<br />
This is in ONE CELL: &nbsp; &nbsp;146301 ASPHALT WORKS: OP BY CONTR-PERM &amp;&nbsp;DRVR<br />
<br />
I only want the first 4 digits of the number above then I want the ALL CAPS to be Upper/Lowercase Formatting.<br />
<br />
Result Desired in ONE CELL: &nbsp;1463 Asphalt Works: Op by Contr-Perm &amp;&nbsp;Drvr &nbsp;(or something close,
</div>
</div>


Data Sample

This is in ONE CELL:    146301 ASPHALT WORKS: OP BY CONTR-PERM & DRVR

I only want the first 4 digits of the number above then I want the ALL CAPS to be Upper/Lowercase Formatting.

Result Desired in ONE CELL:  1463 Asphalt Works: Op by Contr-Perm & Drvr  (or something close,

Copy Partial Data from Cell (omit 2 digits) and Convert to Upper/Lowercase

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