ExcelMAC地址转换公式

冒号转横杠

=UPPER(MID(H2,1,2)&"-"&MID(H2,4,2)&"-"&MID(H2,7,2)&"-"&MID(H2,10,2)&"-"&MID(H2,13,2)&"-"&MID(H2,16,2))

原字符串b8:8a:60:d5:ad:db，转换后B8-8A-60-D5-AD-DB

只有两杠的转横杠

=UPPER(MID(B2,1,2)&"-"&MID(B2,3,2)&"-"&MID(B2,6,2)&"-"&MID(B2,8,2)&"-"&MID(B2,11,2)&"-"&MID(B2,13,2))

原字符串507B-9D71-8D15，转换后50-7B-9D-71-8D-15