Hi,

I would like to take the following entry in a cell xxxx.xxxx.xxxx and change it to xx:xx:xx:xx:xx:xx

For example Cell A1 contains 001C.234F.E293
I want Cell B1 to contain the same value but formatted this way 00:1C:23:4F:E2:93

I need to replace the full stops with ":" - but may not be necessary with the next requirement
I need every 2nd character to be preceeded with ":"

I can't seem to make a single formula that will do this in one go. I will have 1,000's of these to so hence the need for a formula.

Any help is greatly appreciated.