title: How to get only the Surname in a range of cells?
body: <p>I have a spreadsheet having a column of names. Now, in another sheet I want to have the surnames from the aforementioned column to be displayed in a dropdown. How can I do this?</p>
  
  <p>The names look like this:</p>
  
  <p><code>Surname, FirstName</code></p>
  
  <p>And there are also people from the same household having the same surnames. There are no people with the same surname that belong to different households. So I kind of want to get the surnames to identify that household.</p>