Combining Contents of two cells whilst preserving text coloring

Hi Guru's!

I've been stuck trying to solve a problem for combining the contents of two cells into one cell.

I am trying to Maintain the cell formatting - in particular the text color - of the two cells, however the text always seems to revert to the default color of the cell - and all other formats are lost.

Is there a way around this so that when i combine the values of two cells the colors of the text in both cells is preserved?

Kind regards
Jordan

Thanks for your reply Millz, I was thinking of using something like this iterative loop to add and color one letter at a time

Please Login or Register  to view this content.

That may be a bit confusing so I've simplified it to this (assume that all necessary variable declarations are made)

Please Login or Register  to view this content.