Italicize the second line in an excel cell (after a line break.)

[ncguzzo]

Hello. I am trying to italicize only part of my excel cell. I know there is code to assist with this but when I enter what I have found, it italicizes the entire cell. I am including an excel of what I need:

C. N. Arena (RA, N) - hit ALT + E to achieve the line break Fairfield University

 

[Scott Huish]

Are there only ever 2 lines in the cell?

 

[ncguzzo]

I only want to Italicize the second line in my cell, the cell I exhibited is one cell. I also want to do an entire column like this, instead of manually italicizing each cell's second row.

 

[Scott Huish]

I understand that, but it changes the answer if there is a 3rd line or a 4th line in addition to that. So again, I ask will there only ever be 2 lines of text in the cells?

 

[ncguzzo]

Yes. For this particular sheet, there will only be two lines per cell in the same exact format.

 

[Scott Huish]

Adjust range as necessary

Sub test()
Dim c As Range, r As Long
For Each c In Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row)
    r = InStr(c.Text, Chr(10))
    If r Then c.Characters(r + 1).Font.Italic = True
Next
End Sub

 

[ncguzzo]

It worked - thank you!