I have a book database and I am splitting the Author name into Author First and Author Last columns.
The problem I run into is certain books are authored by a company. I don’t want to split the company name up. Is there a way to identify an company name and then place it in the last name column of the split formula.
Something like this:
If Name is Company x than place in last name column If Name is not Company x than place text before space into last name column.