In EXCEL, How to use Bold formatting of a cell and apply in a "concatenate" function in another cell

Asked

Viewed 4,265 times

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" ??inserir a descrição da imagem aqui

excel

1 answer

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.