0
I have two cells with characters with different color formats, but when using the function Concatenar and other functions to extract the characters in another cell, the color format does not apply as defined in the two cells, such as applying the same colors in the cell that was used in the formula:
=CONCATENAR(ARRUMAR(DIREITA(ESQUERDA(SUBSTITUIR(ARRUMAR(E122);" ";REPT(" ";10));20);50));" ";D122)
Possible duplicate of In EXCEL, How to use Bold formatting of a cell and apply in a "concatenate" function in another cell
– danieltakeshi
I’ll remove the question
– Elienay Junior
Amazing not having an option to apply colors to extracted characters
– Elienay Junior
No need to delete, it is good to have several questions in different ways that direct to the same answer. She needs to be marked as a duplicate.
– danieltakeshi