Just about everything can be asked and answered by AI these days but this was useful
If the original MAC is in Cisco format (xxxx.xxxx.xxxx) e.g. a1b2.c3d4.e5f6 in cell A1
=TEXTJOIN(":",TRUE, MID(SUBSTITUTE(A1,".",""), {1,3,5,7,9,11}, 2))
Add UPPER or LOWER to taste
=UPPER(TEXTJOIN(":",TRUE, MID(SUBSTITUTE(A1,".",""), {1,3,5,7,9,11}, 2)))
=LOWER(TEXTJOIN(":",TRUE, MID(SUBSTITUTE(A1,".",""), {1,3,5,7,9,11}, 2)))
# dash-separated as shown by ipconfig /all on Windows
=TEXTJOIN("-",TRUE, MID(SUBSTITUTE(A1,".",""), {1,3,5,7,9,11}, 2))
Input
a1b2.c3d4.e5f6
Output (lowercase)
a1:b2:c3:d4:e5:f6
Output (uppercase)
A1:B2:C3:D4:E5:F6
Output (dash-separated)
a1-b2-c3-d4-e5-f6
0 Comments