Formatting in one cell differently

Copper Contributor

Hello guys... I need help :)

 

C6 = Standard

My formula:       ="My specific text here:   " & C6

 

Now this is what i want excell to do: 

My specific text here:   Standard

 

Is it even possible to make 2 different formattings of text in the same cell?? Like here, normal + text with full black.

 

Hope to hear from you and thanks in advance

 

 

2 Replies

@Jette_Nissen 

Unfortunately, Excel does not support formatting part of the result of a formula differently from the rest. It's best to place "My specific text here" in one cell, and =C6 in the cell next to it (formatted as bold)

@Hans Vogelaar 

**bleep** thats too bad :) Thanks for your answear tho! :)