extract email address

Extract email addresses or urls or phone numbers
From One Column Only, and Paste the Result in the Same Column, Keeping the Original Order

Is there a way to extract out the emails listed in a spreadsheet row by row in one complete column?

Do you have some data like that:

and you want this result:

It is simple, just follow these steps:

• in your spreadsheet, select the content of the column only - to do that, click the letter of the column (example 'C').
• copy the content
• paste it in the First step: Paste your text here text area
• just below the email results: click in the sort by option
• drag and drop the original text order in the first position
• check the check-box enter at the end of the line
• click copy just below the resulting list
• go back on your spreadsheet, select the field you want to paste the result in
• paste the result

Warning: if there is some cells in your original document with no email address, or with more than one email addresses, this method will fail. If this is the case, you have to delete them manually before extracting data