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.
|First column||Second column||Result|
Write me to "firstname.lastname@example.org", dear friend!
|dome wall email@example.com!