Basically all I want to do is have the cells in a certain column auto-format to a Mac Address format. So if I enter 11AABB22FF00 it automatically changes to 11:AA:BB:22:FF:00. Anyone know how to do this? I’m an excel n00b.
Probably the best bet would be format - cells - custom and enter your own format that way
EDIT: Forgot these have letters, that won’t work. All the ways I’m thinking of involve 6 2-digit columns which is a PITA
Yep tried the custom formatting…couldn’t get that to work…Also tried a formula in a helper cell? That also didnt work.
I got it to work with 6 helper columns.
You can hide them once you’re formatted up.
A B C D E F G H
0011A158CB10 00 11 A1 58 CB 10 00:11:A1:58:CB:10
You would put the MAC into A, then B =LEFT(A,2) then C = MID(A,3,2) , D = MID (A,5,2) etc. then H would =CONCATENATE($A1,":","$B1,":" etc.)
Sorry to be an asshole but how do I go about putting everything in? Right now my D column is the host to the MAC addresses. Will this auto format them?
PM me ur email, I’ll send you the worksheet I had it in and you can just copy/paste/update yours