In this article, I’ll give you examples of how to add, remove, or change the separator for MAC addresses in MS Excel or OO Spreadsheet.Īdding a seperator (change 0123456789ab into 01-23-45-67-89-ab) =CONCATENATE(MID(A2 1 2) ”-“ MID(A2 3 2) ”-“ MID(A2 5 2) ”-“ MID(A2 7 2) ”-“ MID(A2 9 2) ”-“ MID(A2 11 2)) The standard format for printing MAC addresses in human-friendly form is six groups of two hexadecimal digits, separated by hyphens (-) or colons (:), in transmission order, e.g. Yesterday someone asked me how to convert a data string to a MAC address. As I’m currently working a lot with Excel, I get a lot of questions like “How do I do this?” or “How do I do that?”.
