You'll need to pull the first names into a different column. While you can
do that with formulas, it is usually faster & easier to insert two new
columns, copy & paste the names into the left new column, and then use
Data|Text to Columns on that copied data, splitting the names where there's a
comma or space, depending on how the list is set up.