Hello,
With the function concatenate, how can we
A) Ask to get the same format as the original cell
B) Force a color format, like red
Exemple = concatenate(A1; " "; A2; " "; A3)
I would like that
1) A1 displays the same color and number format as the cell A1 (for example
green with number #'##0.00
2) Force the format of A2 in red

I know that the function TEXT exists
=concatenate(TEXT (A1;"#'##0.00"); etc.)
But how can I say "red" or "same format as cell A1" ?
Thank you for all advise