I have a file that contains a name field. The first, last and middle initial are in the same field (although not all names have a middle initial). Example: Robert E. Jones
I am wondering if there is a formula that can separate out the full name into separate first, middle & last name fields? I have more than 9k records in this file, so I don't want to have to do each separately. Thanks!