Is there any way to use the CONCATENATE function so that the text in the cell
holding the function will preserve the text colours of the cells which are
being concatenated? It seems to me that a cell which contains a formula
rather than a constant value cannot contain multiple text colours.