How can I extract only the First Name and Last Name from such a list?

Question

excel

There is a payment purpose, where a person wrote a first name, last name and more data, I need to pull out the first and last name using the formula. But the problem is that before that there was no clear indication and people wrote different payment purposes, because of this, not everything is the same. How to do it right, please tell me. I will be very grateful!

Answer 1

There is no silver bullet here. I would copy everything to Google Sheets (there are more possibilities), and there, using REGEXTRACT (), I would pull out the data, perhaps in parts.
You can, for example, look for words with a capital letter in a sentence, or words with "ich" or "vna".