How to highlight people's names from stock text?

S

stepahin2020-04-15 10:40:57

excel

stepahin, 2020-04-15 10:40:57

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

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

Dimonchik, 2020-04-15
@dimonchik2013

is: Python, its libraries and code