Ask Your Question

spreadsheet email entries [closed]

asked 2017-06-06 04:38:33 +0200

lindanaranjo gravatar image

updated 2017-06-07 15:45:36 +0200

EasyTrieve gravatar image

I am doing a spreadsheet with one column containing email addresses. I do not want them to be clickable. How do I change this?

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 2020-10-06 13:04:16.326443


Also now that @m.a.riosv has provided an answer that works, the thing to do next is to click on the check box left of his or her answer till it turns green. That makes it easier for the next person to see what worked. And only you, the original questioner, can click this box. Thanks for the question. I learned something from it too.

EasyTrieve gravatar imageEasyTrieve ( 2017-06-07 15:51:28 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2017-06-06 07:25:02 +0200

EasyTrieve gravatar image

updated 2017-06-06 07:25:57 +0200

Perhaps not the best answer, but possible work around until you find something better:

Use two fields, one for the name and one for the domain, and a 3rd field where you put them together like this:

image description

via C1: =A1 & "@" & B1

I sometimes do this deliberately in databases.

edit flag offensive delete link more


Brilliant! Why didn't I think of that? Thank you!

lindanaranjo gravatar imagelindanaranjo ( 2017-06-06 21:09:36 +0200 )edit

answered 2017-06-07 02:24:53 +0200

m.a.riosv gravatar image

Disabling URL recognition Menu/Tools/Autocorrect/Options - URL recognition when data is entered. Or with [ctrl+M] Menu/Format/Clear direct formatting. to reset from being clickable address.

edit flag offensive delete link more

answered 2017-06-06 21:10:35 +0200

lindanaranjo gravatar image

Easy Treve's solution worked, chopping email addresses up, worked like a charm.

edit flag offensive delete link more


@lindanaranjo, I can see you're new here. Welcome. Please don't use an answer box to comment. Instead use a comment area, or update your original question. Thanks.

EasyTrieve gravatar imageEasyTrieve ( 2017-06-07 15:47:41 +0200 )edit

Question Tools

1 follower


Asked: 2017-06-06 04:38:33 +0200

Seen: 796 times

Last updated: Jun 07 '17