Excel split cells into two

broken image

The default General format works nice in most cases.

broken image
broken image

If you are dealing with names separated with a comma and space like Anderson, Ronnie, then check the Comma and Space boxes under Delimiters, and select the Treat consecutive delimiters as one checkbox (usually selected by default).

broken image