| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional concatenation? | Excel Worksheet Functions | |||
| Concatenation question | Excel Worksheet Functions | |||
| Concatenation issue - Help, PLEASE! | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
| Concatenation Help | Excel Worksheet Functions | |||
Linear Mode
