I have a sting and the code below works find to return the name. I just don't understand what the numbers in the parenthesis are doing?
DEMOGRAPHICS NAME: Donald J. Duck BANK: 451CS
Dim MyText As String
MyText = Trim(Split(Split(Range("A1"), "NAME: ")(1), "BANK:")(0))...