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?”. Yesterday someone asked me how to convert a data string to a MAC address. 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. 01-23-45-67-89-ab, 01:23:45:67:89:ab. 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.

Adding a seperator (change 0123456789ab into 01-23-45-67-89-ab)

An alternate solution was send in by Franco Magliaro see below:

Download Excel For Mac

Free

Removing a separator (change 01-23-45-67-89-ab into 0123456789ab)

or the easy way

  • Sep 21, 2021 Free download Microsoft Excel Microsoft Excel for Mac OS X. Microsoft Excel - The powerful Excel spreadsheet app lets you create, view, edit, and share your files with others quickly and easily.
  • 8/10 (146 votes) - Download Microsoft Excel Mac Free. Microsoft Excel 2016 for Mac is the tool belonging to Microsoft Office to deal with large volumes of numerical data with great comfort and flexibility. If we talk about spreadsheets, we definitely need to mention the program par excellence.

Changing a separator (change 01-23-45-67-89-ab into 01:23:45:67:89:ab)

Install megastat Mac OS There is a plugin. Software.html then click on the link of MegaStat Software Download 2016 (MAC). Excel and they will. MegaStat works with Windows versions of Excel 2016, 2013, and 2010. MegaStat Software Download 2016 (MAC) MegaStat Software Installation Instructions 2011. If playback doesn't begin shortly, try.

Excel for mac air

or the easy way 🙂

Excel Spreadsheet Examples

An alternate solution, to convert the Cisco 0123.4567.89ab MAC format to the F5 load balancer MAC format of 01:23:45:67:89:ab, was send in by Mike Wintrode. To add an extra twist, the F5 load balancer also removes the leading “0” in any pair, so for instance 00:14:0F:80:a3:01 would show as 0:14:f:80:a3:1.

Excel Spreadsheet Download Mac Download

So Mike created the following:

The basic premise utilizes an “IF” statement to check for a preceding “0” and if present to return the next character, and if not to return both characters.

Adam Heath was so kind as to send me an Exel template that uses most of the above formulas (thanks Adam!), which you can download here.

Suggestions for improving this article are welcome, please let me know and drop me a line.