I am trying to remove characters after a space in a string variable. i.e. Change "Johns,Robert James" to "Johns,Robert". In excel, the function is =LEFT(B2,FIND(" ",B2,1)-1) But my file is too big that I cannot change the variable in Excel. How can I write the code to convert the variable? Thanks ... View more