MAC address format convert with excel

 

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)&”:”&MID(A1,5,2)&”:”&MID(A1,7,2)&”:”&MID(A1,9,2)&”:”&MID(A1,11,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)&”-“&MID(A1,5,2)&”-“&MID(A1,7,2)&”-“&MID(A1,9,2)&”-“&MID(A1,11,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)&”.”&MID(A1,5,2)&”.”&MID(A1,7,2)&”.”&MID(A1,9,2)&”.”&MID(A1,11,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

 

 

Leave a Reply