Concatenating with different font sizes (without macros)?

Solved
ButteDuLac Posted messages 534 Status Member -  
ButteDuLac Posted messages 534 Status Member -
Hello,
First, I went to see here https://forums.commentcamarche.net/forum/affich-3692760-excel-concatenation-et-format
But here it is.
I have a workbook (not made by me) with 49 sheets. In each, I include a CONCATENATE in column R.
However, the formula differs from page to page, as the information to concatenate is not contained in the same columns...
So it's difficult to go with a macro.
Is there a code that I could include in my formula so that the information is formatted (font size) in the concatenated cell?
Example:
In A2 = Product description.
In B2 = Product number (000000)
In H2 = Inventory number (0000000-0000)
In R2 =CONCATENATE(H2;CHAR(10);A2;CHAR(10);B2)
Gives, in R2:
[0000000-0000
Product description
000000]
And I would like to obtain:
[0000000-0000
Product description
000000]
Except that instead of BOLD, it would be a larger font size (e.g.: size 14 pts, vs size 12 pts for the Product description).
Directly, without having to go through a macro. Because if now it's [H2;A2;B2], in the next sheet, it could be [F2;A2;J2].
I hope my explanation is clear!!!
Thank you!

Configuration: Windows 7 / Mozilla 11.0

1 answer