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.

MANAGEMENT ACCOUNTING

Developing finance leaders

A good leader recognizes that part of the job is developing the next generation of leaders. Veronica McCann, CGMA, a former division CFO at Commerzbank in Singapore, shares tips on developing future finance leaders.

PROFESSIONAL ISSUES

Belicia Cespedes: A CPA at 17

Through hard work and determination, Belicia Cespedes earned the credential before she was even eligible to vote.

SPONSORED REPORT

How to audit high risk areas

Revenue recognition, internal control over financial reporting, accounting estimates and going concern are areas of audit that have emerged as particularly challenging and complex.