I would love to separate the two names, if some automated mechanism makes that possible. Really don't want to spend hours doing it manually.

Thank you for that formula, but it gives the first name I tried changing the "LEFT" to "RIGHT" and tinkering with the "-1" but each cell is clipping the name differently