Concatenating with different font sizes (without macros)?
Solved
ButteDuLac
Posted messages
534
Status
Member
-
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
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
-
Hello,
Can we hope to receive a response to this post
https://forums.commentcamarche.net/forum/affich-31555586-conversion-excel-pdf-et-lien-hypertexte#p31610455
--
@+ Le Pivert