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
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