I have a long list of names in the format below in one cell (first name comma space last name)
John, Glenn
Bob, Barker
I'm trying to find a non-VBA way to pull out the first name with the comma and then the last name each in a different cell. I searched but found the answers a little confusing. Any help is appreciated.
Max
Bookmarks