Hello,
I have an excel spreadsheet that has embedded e-mails in the cells.
Ex. Cell A1 is titled "Email" and then A2 and so on either say "Yes" or the cell is empty. If the cell says yes there is a hyperlink to the e-mail address so when clicked on it automatically opens your local e-mail editor. I would like to extract the embedded e-mail addresses to their own cell if possible. Is there a way to do this?
I appreciate the help.
I have an excel spreadsheet that has embedded e-mails in the cells.
Ex. Cell A1 is titled "Email" and then A2 and so on either say "Yes" or the cell is empty. If the cell says yes there is a hyperlink to the e-mail address so when clicked on it automatically opens your local e-mail editor. I would like to extract the embedded e-mail addresses to their own cell if possible. Is there a way to do this?
I appreciate the help.