menu

Extract emails


As you may have noticed, most operations rely on the "fact" that the email is in the first column. It should be normally that way.


If the emails are in the second column (or third, or any one, the same for all the rows), you can move columns to put emails to the first place.


But if no column contains emails (different rows have emails in different columns) or emails are stored in the middle of some sentences, and the whole sentences are stored in the first column, this operation may greatly help.


For example:


First column Second column Result
1-700-442-12-33 Peter,
Write me to "b@b.b", dear friend!
subject:dime@fn.fn/123456tgsdfs
dome wall a@a.a!
I remember!
(YVU)
a@a.a
b@b.b
dime@fn.fn



Next operation:


Filter/Search


Customer support


Register program