If you have Excel handy:
\nCell A1 your original MAC
\nCell B1 =SUBSTITUTE(A1,”:”,””)
\nCell C1 =MID(B1,1,4)&”:”&MID(B1,5,4)&”:”&MID(B1,9,4)<\/p>\n
Put original MACs into column A, 1 per cell
\nFill down column B and C<\/p><\/blockquote>\n
In my case,<\/p>\n
D35 is original<\/p>\n
D36: =MID(D35,1,4)&”.”&MID(D35,5,4)&”.”&MID(D35,9,4)<\/p>\n
001DA266FBE6 becomes useable 001D.A266.FBE6<\/p>\n","protected":false},"excerpt":{"rendered":"
I have 140 MAC addresses that I need to find out not only what switch, and switch port they are on, but also which part of the floor. It is a time-consuming slog, especially since the MAC addresses are not … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[237,329],"class_list":["post-1152","post","type-post","status-publish","format-standard","hentry","category-geek","tag-excel","tag-tips"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2NxlE-iA","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":624,"url":"https:\/\/matthannan.net\/blog\/haiku-for-a-mid-novemeber-morning\/","url_meta":{"origin":1152,"position":0},"title":"Haiku for a Mid-November Morning","author":"matthannan","date":"18 November 2014","format":false,"excerpt":"Sky grey, morning clouds. Earth still wet from last night's storm. Wind-dancing oak leaves.","rel":"","context":"In "Life"","block_context":{"text":"Life","link":"https:\/\/matthannan.net\/blog\/category\/life\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2416,"url":"https:\/\/matthannan.net\/blog\/what-i-did-on-my-mid-summer-vacation-day-1\/","url_meta":{"origin":1152,"position":1},"title":"What I Did on My Mid-Summer Vacation: Day 1","author":"matthannan","date":"5 August 2022","format":false,"excerpt":"I took the week of August 1st off in order to build a new shed in the yard. The old shed had a leaking roof and was, generally, falling apart. In order to build the new one, I had to clear the old one out of the way. The new\u2026","rel":"","context":"In "Life"","block_context":{"text":"Life","link":"https:\/\/matthannan.net\/blog\/category\/life\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_095958-scaled.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_095958-scaled.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_095958-scaled.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_095958-scaled.jpg?resize=700%2C400 2x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_095958-scaled.jpg?resize=1050%2C600 3x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_095958-scaled.jpg?resize=1400%2C800 4x"},"classes":[]},{"id":2464,"url":"https:\/\/matthannan.net\/blog\/what-i-did-on-my-mid-summer-vacation-day-5\/","url_meta":{"origin":1152,"position":2},"title":"What I Did on My Mid-Summer Vacation: Day 5","author":"matthannan","date":"31 August 2022","format":false,"excerpt":"Forecast for the day is a heat advisory. If we haven't already been under one, having one today was really bad news. I took advantage of not being able to work out in the yard to get caught up on the checking account and paying the couple of bills that\u2026","rel":"","context":"In "Geek"","block_context":{"text":"Geek","link":"https:\/\/matthannan.net\/blog\/category\/geek\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/mqtt-publish-subscribe-3.png?fit=1024%2C320&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/mqtt-publish-subscribe-3.png?fit=1024%2C320&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/mqtt-publish-subscribe-3.png?fit=1024%2C320&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/mqtt-publish-subscribe-3.png?fit=1024%2C320&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1947,"url":"https:\/\/matthannan.net\/blog\/solar\/","url_meta":{"origin":1152,"position":3},"title":"Solar","author":"matthannan","date":"19 June 2020","format":false,"excerpt":"We just signed up. This will be interesting. I like being deep into mid-life and signing long-term notes.","rel":"","context":"In "Life"","block_context":{"text":"Life","link":"https:\/\/matthannan.net\/blog\/category\/life\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2438,"url":"https:\/\/matthannan.net\/blog\/what-i-did-on-my-mid-summer-vacation-day-2\/","url_meta":{"origin":1152,"position":4},"title":"What I Did on My Mid-Summer Vacation: Day 2","author":"matthannan","date":"5 August 2022","format":false,"excerpt":"Definitely feeling my age, I got started on Day 2. The day's goal was to clear the platform and assess the leveling situation. Stretch goal was to get the three 4\" x 4\" x 12' pressure-treated beams on site. Of course, there were delays in getting out in the cool\u2026","rel":"","context":"In "Life"","block_context":{"text":"Life","link":"https:\/\/matthannan.net\/blog\/category\/life\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_172837-1-scaled.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_172837-1-scaled.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_172837-1-scaled.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_172837-1-scaled.jpg?resize=700%2C400 2x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_172837-1-scaled.jpg?resize=1050%2C600 3x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220730_172837-1-scaled.jpg?resize=1400%2C800 4x"},"classes":[]},{"id":2450,"url":"https:\/\/matthannan.net\/blog\/what-i-did-on-my-mid-summer-vacation-day-3\/","url_meta":{"origin":1152,"position":5},"title":"What I Did on My Mid-Summer Vacation: Day 3","author":"matthannan","date":"5 August 2022","format":false,"excerpt":"If I had a late start yesterday, I was even more delayed on the third day. First, I was informed that \"the family\" had decided that they wanted ad-blocking turned back on on the pfSense firewall. I was told to turn this off several months ago. Of course, nothing is\u2026","rel":"","context":"In "Geek"","block_context":{"text":"Geek","link":"https:\/\/matthannan.net\/blog\/category\/geek\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220801_120145-scaled.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220801_120145-scaled.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220801_120145-scaled.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220801_120145-scaled.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220801_120145-scaled.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/matthannan.net\/blog\/wp-content\/uploads\/2022\/08\/IMG_20220801_120145-scaled.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/posts\/1152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/comments?post=1152"}],"version-history":[{"count":1,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/posts\/1152\/revisions"}],"predecessor-version":[{"id":1154,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/posts\/1152\/revisions\/1154"}],"wp:attachment":[{"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/media?parent=1152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/categories?post=1152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/matthannan.net\/blog\/wp-json\/wp\/v2\/tags?post=1152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}