i am looking to extract the surname form a cell in a spreadsheet. The cell will have mixed data e.g John Harold Smith 485734953
but there would also be time when it will be John Smith 453459 or J Smith 435973 so i’ve used an array and used .split (" ") to capture the first name but is there a formula thta i could use to capture the surname? as it stands i can’t use MyArr(1) as it will take the middle name for some of the rows.
can anyone help me here?