0
I have a small table, I intend to use the bold formatting of the cell "A20" of the number '2001-T' and apply in the function "concatenate" of the cell "F20", but any type of formatting I do in the cell "A20" does not apply also in the cell "F20" along with the function "concatenate" used, how do I apply the same formatting used in cell "A20"?? 2001-T in cell "F20" ??
2
You cannot apply format to a formula or copy formatted content.
CONCATENAR copies only the text. If it was a number or date formatting, you can use the function TEXTO, which can apply a format (for example =TEXTO(HOJE();"DD/MM/AA")), but not bold, italic and edges for example.
To do this type of formatting, you need to create a function in VBA, unfortunately it is the only way.
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.