用Excel 转换MAC地址格式并批量生成配置

80F62EB9DE50 to 80F6.2EB9.DE50

=MID(A1,1,4)&"."&MID(A1,5,4)&"."&MID(A1,9,4)

80F62EB9DE50 to 80:F6:2E:B9:DE:50

=MID(A1,1,2)&":"&MID(A1,3,2)&":"&MID(A1,5,2)&":"&MID(A1,7,2)&":"&MID(A1,9,2)&":"&MID(A1,11,2)

批量生成配置

&&表示数据源

""表示对数据源新增的内容

="config exclusionlist add "&C7&