Another approach :
I searched the IMDB.com website for Attack of the Killer Tomatoes. Using this url : https://www.imdb.com/title/tt0080391/?ref_=fn_al_tt_1 you can see a list of three actors towards the top of the page.
They list as : Stars: David Miller, George Wilson, Sharon Taylor
Highlight the three names and copy.
Go to the MAIN SHEET in your workbook and paste the three names in Column I for the corresponding film. In this case that would be row #2 ... so paste in I2 .
Then click the FORMAT button provided in your revised workbook (attached) and the macro will do the rest.
Code:
Option Explicit
Sub FormatActors()
Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1)), TrailingMinusNumbers:=True
With Columns("I:M")
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Font.Name = "Arial"
.Font.Size = 12
End With
End Sub
Bookmarks