I figured out a workaround in Google Sheets but I can't figure it out in Excel.
<a href="http://www.smartinsights.com/mobile-marketing/mobile-marketing-analytics/mobile-marketing-statistics/">new report</a>
I'd like a way to separate the URL and link text from above into 2 columns
A B
http://www.smartinsights.com/mobile-...ng-statistics/ new report
Thanks for any suggestions.
Bookmarks