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 on the letter of the column (example 'C').
• copy the content
• paste it in the "Paste your text here" text area
  
  
• click in the "sort by" option (just above the text area) - and drag and drop the "original text order" in the first position
• click in the "format", select the "custom separator", delete the ';' in the text area
• check the check-box "enter at the end of the line"
  
  
• click on "Extract"
• click on result and copy the content
  
  
• 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