How- seperate a combined list by filtering out first list of names

B

Briana

if i combined lists A and B of names into one list, how do I seperate them
again? Is there a way to filter out list A, leaving only list B remaining?
 
V

Vito

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
 
Top