How to make part of a string Bold and add it to a excel Cell?

Question

Hello i try to make a part of a string bold and then add it to an excel Cell. So it looks like:

What i tried:

Inside Excel using a range:

excelSheet.get_Range("A" + 16, "D" + 16).Font.Bold = true;

But this makes everything bold....

Then i tried:

"<b>" + text + "<b>"

and had no success.

So i make something wrong. Any help or advise would be great and thanks for your time.

EDIT: Working C# Code:

Excel.Range range1 = excelSheet.Range["A36"];
Excel.Characters test = range1.get_Characters(21, 4);
test.Font.Bold = true;

I'm not familiar with `c#` but have you tried selecting the characters themselves? ref: http://stackoverflow.com/questions/10295380/excel-vba-make-part-of-string-bold — Jordan, May 04 '16 at 14:06
oh well this didnt showed up in my research. i give it a try. — opelhatza, May 04 '16 at 14:09

Gary's Student · Accepted Answer · 2018-10-05T14:41:21.740

You can't make parts of a string bold, but you can make characters in a cell bold:

Sub BoldAndBeautiful()
    With Range("A68")
      .Value = "Test 1234 Test"
      .Characters(Start:=1, Length:=4).Font.FontStyle = "bold"
      .Characters(Start:=11, Length:=4).Font.FontStyle = "bold"
    End With
End Sub

Basically do it in two steps. First put the text in the cell using the Value of the Range object and then apply the font using the Characters of the Range object.

Note that some systems use an "HTML-type" method to format parts of a string, that is they embed markers to define where formatting starts and stops. Excel is not one of them.

Just adapt this to your c# code.

Works with a little work and thanks. I also edited my question with the solution. — opelhatza, May 04 '16 at 14:43

How to make part of a string Bold and add it to a excel Cell?

1 Answers1