An example source cell would be something like:
Some:Thing:random:here
I want to transform it to this (reversing the order of each group):
here:random:Thing:Some
I would prefer a formula, without using macros, if possible.
This is the formula I've been trying to manipulate to change the last part of an IP.
=IF(C12="","",SUBSTITUTE(LEFT(SUBSTITUTE(C12,".","."&REPT("",LEN(C12))),LEN(C12)*2)&MID(SUBSTITUTE(C12,".","."&REPT("> ",LEN(C12))),LEN(C12)*2,LEN(C12))&"5"," ",""))