If you have a list of MAC addresses and you need to add colons to it, open Microsoft Excel and paste the MAC addresses in the first column. In the second column, paste the formula below.
=LEFT(A1,2)&":"&MID(A1,3,2)&":"&MID(A1,5,2)&":"&MID(A1,7,2)&":"&MID(A1,9,2)&":"&RIGHT(A1,2)
This is very helpful when you are trying to do an import into a program such as FOG.
great post . thanks for providing such important information about MAC Address
ReplyDeleteSpoof MAC Address
It's amazing that you can use Microsoft Excel to convert your MAC Address .Thanks for sharing this method .
ReplyDeleteRegards
Silvester Norman
Change Mac Address
If you are like me and your MAC address had 16 digits, use this one.
ReplyDelete=LEFT(A1,2)&":"&MID(A1,3,2)&":"&MID(A1,5,2)&":"&MID(A1,7,2)&":"&MID(A1,9,2)&":"&MID(A1,11,2)&":"&MID(A1,13,2)&":"&RIGHT(A1,2)