Automate text to column

[Jr1986]

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.

[Leith Ross]

Hello Jr1986,

Welcome to the Forum!

It would help to know where the list is located. Is it in a text file or on a another worksheet?

Sincerely,
Leith Ross

[Jr1986]

The list drop down box is on Sheet 1 in cell A9, and the actual data for the list is on sheet 2 column A.