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

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", however any type of formatting that I do in cell " A20 "does not apply also in cell" F20 "along with the" concatenate "function used, how do I apply the same formatting used in cell" A20 "?? in the '2001-T' number of the 'F20' cell ??

    
asked by anonymous 10.10.2018 / 18:18

1 answer

2

You can not format a formula or copy content with formatting.

CONCATENAR copies only the text. If it were a number or date format, you could use the TEXTO function, which can apply a format (for example =TEXTO(HOJE();"DD/MM/AA") ), but not bold, italic, and borders for example.

To do this type of formatting, you need to create a function in VBA, unfortunately it is the only way.

    
10.10.2018 / 18:36