Hi I have a drop down list with name and what I require is when a name is selected in say A1, then the name is split into first and second names in cells B1 and C1, is this possible so that every time I select a name then the relevent first and second names are displayed in the those cells?

Thanks in advance.