Hello,
I have an Excel worksheet with several thousand email addresses. The email addresses are all in different columns. It is mixed in with their names, phone numbers, street addresses etc. What function/code could be written to search for the "@" symbol, since this is the only thing they will all have in common and then copy or cut/paste the cell with the email address to a new column. So the first email it finds would go in let's say column G Row 1 the next it finds would go in Column G Row 2 all the way down Column G until all emails are copied/cut pasted to it. I suppose you would also have to highlight the range to search so it does not go to column G in the search.
Any help you can provide is greatly appreciated on this matter.
Thank you.
I have an Excel worksheet with several thousand email addresses. The email addresses are all in different columns. It is mixed in with their names, phone numbers, street addresses etc. What function/code could be written to search for the "@" symbol, since this is the only thing they will all have in common and then copy or cut/paste the cell with the email address to a new column. So the first email it finds would go in let's say column G Row 1 the next it finds would go in Column G Row 2 all the way down Column G until all emails are copied/cut pasted to it. I suppose you would also have to highlight the range to search so it does not go to column G in the search.
Any help you can provide is greatly appreciated on this matter.
Thank you.
