Potentially complex formula
Hello. This is my first post on here so bear with me. I have a workbook with full name cells that have first and last name data that are formatted as follows: "Mickey De La Ratones (nickname)" wi...
Forum Discussion
You could try Flash Fill. But you have to provide several examples to get the AI to recognize the pattern.
But you will never get a 100% solution.