Excel

Copper Contributor

Hello

I am using 'CONCAT' and 'FILTER' to draw together a book title and its author. These are combined in  one cell albeit on separate lines. Is there a way to convert the first line to BOLD and leave the second line untouched as shown below.

 

Iriwel_0-1618487785313.png

 

Would appreciate any help possible.

 

Thanks in advance.

 

James C

 

2 Replies

@Iriwel 

No, it is not possible to format part of the result of a formula differently than the rest.

So it'd be better to have the book title and the author in two separate cells.

Hans ... thanks for your reply.