Extract Text from the Center of a Cell

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 :)
TechnologyManguAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
Try:

=MID(A1,FIND(".",A1)-4,14)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.