So I have a list of names arranged Last name, First name. I'm wondering how can you make it so the Last name is in Column A and First name is in column B everytime you select one of the names. I looked this up and saw that text to columns thing but it seems to only work once. Is there a way to make it automatically do it everytime I select someones name. Thanks in advance.