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&

网友评论