MAC address need to add colons

Posted by nan on Stack Overflow See other posts from Stack Overflow or by nan
Published on 2010-03-31T15:10:02Z Indexed on 2010/03/31 15:13 UTC
Read the original article Hit count: 414

Filed under:
|

Kevin your response was helpful with the MAC address question. I wanted to ask you if you have like 2600 MAC address the formula you provided =LEFT(A2,2)&":"&MID(A2,3,2)&":"&MID(A2,5,2)&":"&MID(A2,7,2)&":"&MID(A2,9,2)&":"&RIGHT(A2,2) how do I replace A1 with blank so all of column A gets converted

© Stack Overflow or respective owner

Related posts about mac

Related posts about address