Example:- Dim string1= "CL2323 - Master - Rob Fernandez" string1.split("-")(1) ... I want this to return the value as Master - Rob Fernandez However it returns only Master.