Ask Your Question
1

spreadsheet email entries

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 close merge delete

Comments

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
2

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
0

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

Comments

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

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

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

Comments

@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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 62 times

Last updated: Jun 07 '17