adding character quickly

  1. S

    Formula to add a ":" after every 2 characters in a cell?

    Hi Everyone, I have searched online and in help but can't seem to find the best solution... I have values like 00904BB303D6 that need to become: 00:90:4B:B3:03:D6 (the value is always 12 digits, and the : needs to appear every two digits.) Is there a formula that can easily do this for me? Your...

Some videos you may like

This Week's Hot Topics