Convert plain numbers to MAC addresses with Excel

We use the following formula if you need a – between the octets:
 =MID(c2,1,2)&"-"&MID(c2,3,2)&"-"&MID(c2,5,2)&"-"& MID(c2,7,2)&"-"&MID(c2,9,2)&"-"&MID(c2,11,2)

We use the following formula if you need a :
between the octets:
=MID(c2,1,2)&":"&MID(c2,3,2)&":"&MID(c2,5,2)&":"& MID(c2,7,2)&":"&MID(c2,9,2)&":"&MID(c2,11,2) - See more...