Remus RIGO's blog

Photography/Design/Vector/Programming help

2024-08-01

Format text as MAC Address

=TEXTJOIN(":", 1, MID(B2, SEQUENCE(6,1,1,2), 2))
Posted by Remus Rigo at 10:14 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Excel
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

About Me

Remus Rigo
View my complete profile

Search

Pages

  • Home

Blog Archive

  • ▼  2024 (2)
    • ▼  August (1)
      • Format text as MAC Address
    • ►  June (1)
  • ►  2023 (4)
    • ►  April (1)
    • ►  January (3)
  • ►  2022 (8)
    • ►  November (1)
    • ►  October (1)
    • ►  June (1)
    • ►  May (1)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2021 (15)
    • ►  December (2)
    • ►  November (1)
    • ►  July (1)
    • ►  April (2)
    • ►  February (1)
    • ►  January (8)
  • ►  2020 (17)
    • ►  December (3)
    • ►  November (1)
    • ►  October (1)
    • ►  September (2)
    • ►  July (1)
    • ►  June (1)
    • ►  March (1)
    • ►  February (2)
    • ►  January (5)
  • ►  2019 (30)
    • ►  December (2)
    • ►  November (2)
    • ►  August (5)
    • ►  July (3)
    • ►  June (4)
    • ►  April (3)
    • ►  March (1)
    • ►  February (6)
    • ►  January (4)
  • ►  2018 (37)
    • ►  December (2)
    • ►  November (1)
    • ►  October (3)
    • ►  August (1)
    • ►  July (2)
    • ►  June (5)
    • ►  May (6)
    • ►  April (14)
    • ►  March (2)
    • ►  February (1)
  • ►  2017 (7)
    • ►  December (1)
    • ►  June (1)
    • ►  March (1)
    • ►  February (2)
    • ►  January (2)
  • ►  2016 (2)
    • ►  December (1)
    • ►  November (1)
  • ►  2015 (7)
    • ►  October (2)
    • ►  September (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
  • ►  2014 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  September (3)
    • ►  August (5)
    • ►  March (2)
  • ►  2013 (6)
    • ►  December (2)
    • ►  June (1)
    • ►  March (2)
    • ►  February (1)
  • ►  2012 (11)
    • ►  May (2)
    • ►  April (1)
    • ►  March (4)
    • ►  February (4)

Labels

Windows (87) Command prompt (40) Ubuntu (19) Chrome (10) PowerShell (10) error (10) Linux (9) Terminal (8) Windows 10 (8) Registry (7) Excel (5) Photoshop (4) backup (4) cmd (4) services (4) Active Directory (3) Internet Explorer (3) Outlook (3) Shell Folders (3) Skype (3) Theme (3) Windows Explorer (3) dism (3) domain (3) facebook (3) Adobe Reader (2) AntiVirus (2) Control Panel (2) Icons (2) JavaScript (2) Microsoft (2) Policy (2) Transparency (2) Unity (2) User (2) VBScript (2) WIM (2) Windows 7 (2) fix (2) grub (2) printer (2) restore (2) shortcut (2) time (2) Access (1) Adobe (1) Adobe Illustrator (1) Ai (1) BIOS (1) BitLocker (1) Brother (1) C# (1) C++ (1) CLSID (1) Chaotica (1) CorelDRAW (1) Cursors (1) Dell (1) Desktop Gadgets (1) Desktop Icons (1) FTP (1) GUID (1) GeoSetter (1) Google (1) Group Policy (1) Hardware (1) Inkscape (1) Java (1) Lightroom (1) Log (1) Login Screen (1) MAC (1) Monitor (1) NTP (1) NameSpace (1) Notepad (1) Offce (1) Office 2016 (1) Opacity (1) Photoshop CS6 (1) RAM (1) SAP (1) Special Folder (1) Task Sequence (1) Teams;Windows;Mac (1) TelnetCE (1) URL (1) UUID (1) VB.NET (1) Visual Studio (1) WavelinkTE (1) WinAmp (1) Windows 8 (1) Windows Server (1) Windows Server 2003 (1) WindowsCE (1) autologin (1) batch file (1) boot (1) browser (1) chkdsk (1) clock (1) computername (1) desktop (1) driver (1) duplicates (1) exif (1) exiftool (1) file manager (1) font (1) fractals (1) home group (1) label (1) parameter (1) password (1) print (1) rename (1) subst (1) torrent (1) touch screen (1) troubleshoot (1) tweak (1) username (1) utorrent (1) virtual drive (1) vmware (1) wallpaper (1)

Followers

profile for Remus Rigo at Super User, Q&A for computer enthusiasts and power users
profile for Remus Rigo at Stack Overflow, Q&A for professional and enthusiast programmers
profile for Remus Rigo at Server Fault, Q&A for system administrators and desktop support professionals
profile for Remus Rigo at Ask Ubuntu, Q&A for Ubuntu users and developers
Flag Counter
Powered by Blogger.