Creating hyperlinks in Excel

BY J. CARLTON COLLINS, CPA

Q: My accounting software enables me to export my customer data to Excel, but the customers’ email addresses do not show up as clickable hyperlinks. I must edit each email address one at a time to delete the leading apostrophe to convert the text-based email address to clickable email addresses. Is there an easier way to do this?

A: Excel 2010, 2007, and 2003 provide a hyperlink function that converts text to a clickable hyperlink. In the example below, I entered =HYPERLINK(L2) in cell M2, which converts the text-based data in cell L2 into a clickable hyperlink. I then copied this formula (in cell M2) down to convert the other text-based email addresses to clickable email addresses.

Caution: Using the Copy, Paste Values commands to convert the =HYPERLINK formula to regular text removes the hyperlink.

SPONSORED REPORT

The technology assessment engagement

Are you working with the best technology? Do you know how to help your clients determine if their technology stack measures up? In this free report, J. Carlton Collins, CPA, explains how to answer those questions via a technology assessment engagement.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.