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:...
Or
=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,3,0,":"),6,0,":"),9,0,":"),12,0,":"),15,0,":")