hey there, just figured it out. Its because 95% of column A (the column im drawing the data from), has cells where the surname is followed by a space. That's why your formula wasnt picking it up.
On closer inspection, it was only picking up the surnames with no space at the end
When i indiviually go and delete the space, the surname magically appears in column C (Column B has the 'firstname' formula)
is there a formula for deleting that space for all that have one in their after the surname?
