Forum Discussion
Adding a colon to every 2 characters within a cell
Hi all, I have a column of data containing mac addresses eg aabbccddeeff which i extracted from my wireless LAN controller. I would like to know how to add a colon to every 2x characters, eg aa:...
Try this one, assuming aabbccddeeff is in A1
=MID(A1,1,2)&":"&MID(A1,3,2)&MID(A1,5,2)&":"&MID(A1,7,2)&MID(A1,9,2)&":"&MID(A1,11,2)
A quick and dirty solution. But it works 🙂
