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 ...

Over years of working with Excel, I have stumbled ... TEXTSPLIT splits text into multiple columns or rows using a delimiter.