Format : 001122334455 -> 00:11:22:33:44:55
From MS Excel,
1. Put a raw MAC address : ex) 001122334455 on A1
2. Copy and paste below on B1
=MID(A1,1,2)&”:”&MID(A1,3,2)&”
3. See the MAC is becoming 00:11:22:33:44:55
Format : 001122334455 -> 00-11-22-33-44-55
From MS Excel,
1. Put a raw MAC address : ex) 001122334455 on A1
2. Copy and paste below on B1
=MID(A1,1,2)&”-“&MID(A1,3,2)&”
3. See the MAC is becoming 00-11-22-33-44-55
Format : 001122334455 -> 00.11.22.33.44.55
From MS Excel,
1. Put a raw MAC address : ex) 001122334455 on A1
2. Copy and paste below on B1
=MID(A1,1,2)&”.”&MID(A1,3,2)&”
3. See the MAC is becoming 00.11.22.33.44.55
Format : 001122334455 -> 0011.2233.4455
From MS Excel,
1. Put a raw MAC address : ex) 001122334455 on A1
2. Copy and paste below on B1
= MID(A2,1,4)&”.”& MID(A2,5,4)&”.”&MID(A2,9,4)
3. See the MAC is becoming 0011.2233.4455
Format : 00:11:22:33:44:55 -> 00-11-22-33-44-55
From MS Excel,
1. Put a raw MAC address : ex) 00:11:22:33:44:55 on A1
2. Copy and paste below on B1
= MID(A1,1,2)&”-“&MID(A1,4,2)&”-“&MID(A1,7,2)&”-“&MID(A1,10,2)&”-“&MID(A1,13,2)&”-“&MID(A1,16,2)
3. See the MAC is becoming 00-11-22-33-44-55