I have a column that utilizes the email hyperlink option. When I export my data to excel the email column data has the html tags as well as the persons email:
<a href="mailto:John.X.Smith@anywhere.com">John.X.Smith@anywhere.com</a>
I have a separate tab that displays a view of the same data just filtered by close date that when I export the data into excel the html tag does not display just the email:
John.X.Smith@anywhere.com
So how can I make the export from each tab only display the email address?