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...