ExcelBanter - Colourized Concatenation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Colourized Concatenation (https://www.excelbanter.com/excel-worksheet-functions/77596-colourized-concatenation.html)

Colourized Concatenation

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.

Colourized Concatenation

You are correct: a cell which contains a formula rather than a constant
value cannot contain multiple text colours.

If you need to preserve the colours, then use a helper cell. Copy the cell
with the concat formula and past/special as value into the helper cell. Then
format the helper cell

--
Gary's Student

"Lucas Swanson" wrote:

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.