MAC address need to add colons
- by nan
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