Guest User

Untitled

a guest
Jun 25th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. =IF(ISBLANK([MAC Address]),6,(LEN([MAC Address])=17) +(MID([MAC Address],3,1)=":") +(MID([MAC Address],6,1)=":") +(MID([MAC Address],9,1)=":") +(MID([MAC Address],12,1)=":") +(MID([MAC Address],15,1)=":"))=6
Add Comment
Please, Sign In to add comment