<div>
<div class="content wysiwyg-content">
Assuming I have:<br />
<br />
&nbsp;905 &nbsp; &nbsp;0026.9986.77b3 &nbsp; &nbsp;DYNAMIC &nbsp; &nbsp; Gi3/0/15<br />
<br />
in a cell, how do I extract the MAC Address &quot;0026.9986.77b3&quot; into a different cell using a formula? I know this is simple :)
</div>
</div>


Assuming I have:

 905    0026.9986.77b3    DYNAMIC     Gi3/0/15

in a cell, how do I extract the MAC Address "0026.9986.77b3" into a different cell using a formula? I know this is simple :)

Extract Text from the Center of a 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.