We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

I have email addresses and want them as links, but the are normal text. How to convert them? [closed]

asked 2012-05-25 22:17:21 +0200

anonymous user


I have a list of email addresses in Calc and they are normal text, how do I convert them to clickable email address's ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 04:39:30.248343

1 Answer

Sort by » oldest newest most voted

answered 2012-05-29 22:32:00 +0200

Jay Lozier gravatar image
  1. Select cell with the text email address and highlight the text
  2. From Insert select Hyperlink then select "Mail & News"
  3. If the dialog box does not default to E-mail, select the E-mail button.
  4. The text field should have the email address.
  5. In the Hyperlink Dialog the copy the email address in the text field into the Receiver field and then click on Apply.
  6. Clicking on the cell should open your default email client in your system defaults
edit flag offensive delete link more


Works for me (still would be nice to have a mechanism for bulk-converting several email addresses to links at once).

qubit gravatar imagequbit ( 2013-03-13 08:05:15 +0200 )edit

Question Tools


Asked: 2012-05-25 22:17:21 +0200

Seen: 6,973 times

Last updated: May 29 '12