Power Query - columns comparsion with text splitting

Hi everyone, I have a table with 3 columns: 1. text, some cells included full names after a delimiter, 2. Name, and 3. Surname. I want to add a custom column, and there should be only text before the last delimiter if there is any value compatible with values from the Name or Surname columns. If there are no names or surnames available, no changes will be made. Any advice? Thank you in advance.