I have two cells with characters with different color formats, but when using the Concatenar function and other functions to extract the characters in another cell, the color format does not apply as defined in the two cells, same colors in the cell that was used in the formula:
=CONCATENAR(ARRUMAR(DIREITA(ESQUERDA(SUBSTITUIR(ARRUMAR(E122);" ";REPT(" ";10));20);50));" ";D122)
