How do I extract muiltiple email address from a distribution list?
The entire list is posted in a single row.
I thought about to text to columns first, delimited with ; and paste Transpose, to be in column
After the list is in column i use the formula =MID(A6,FIND("<",A6)+1,FIND(">",A6)-FIND("<",A6)-1) to extract the emails
There is another way to extract all the email with just 1 formula, instead use all these steps?
Thank you
The entire list is posted in a single row.
I thought about to text to columns first, delimited with ; and paste Transpose, to be in column
After the list is in column i use the formula =MID(A6,FIND("<",A6)+1,FIND(">",A6)-FIND("<",A6)-1) to extract the emails
There is another way to extract all the email with just 1 formula, instead use all these steps?
Thank you