Here is a simple Excel formula that helps me to convert the MAC addresses from the standard colon delimited values (:), to the dot (.) delimited values used by most networking equipment such as Cisco Switches and Routers.