To separate first and last names using delimiters: Excel will split the first and last names into two columns. You can also use this to separate first, middle, and last names. Another easy way to ...