Is there a special character separating the firstname from the lastname
such as a space or pipe|?

If so, then you can easily do it with Data>Text to Columns using tha
character as the delimiter and then on the 3rd window, highlight colum
A and choose "do not import column(skip)".  This will leave the selec
column(s) out