How to highlight people's names from stock text?

Question

excel

There are lines of text, most of which presumably contain people's names. Is there a tool that can extract the name from each line? Web, terminal application or macro for Google Sheets / Excel.

Example:
Anna Kalashnikova → Anna
Julia Kovalchuk/Yuliya Kovalchuk → Julia
Maria Batkhan ENGLISH TEACHER → Maria
SHEIN Russia →
Your women's magazine →
OLGA BEREK | BUSINESS BLOG → Olga
Akhmed Aliaskhabov → Akhmed
Videos_prikol Video Jokes →
YANA LEVENTSEVA → Yana

More data for example
https://docs.google.com/spreadsheets/d/1ccn82cR2kb...

Answer 1

is: Python, its libraries and code