Ask Your Question

How can I avoid that a Calc cell with an @ is not formatted as an e-mail address?

asked 2015-08-03 22:57:46 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have a column of text that is syntactically email addresses. Some of them a formatted under my control (font, size), but some are formatted in a way that I can't change and as e-mail addresses. I would like them all to be considered as text.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-08-04 11:04:18 +0200

pierre-yves samyn gravatar image

Hi - AutoCorrect +1

And to convert cells that already contains @:

  • Edit Find & Replace
  • Search for @
  • Replace with &
  • Other options, check Regular expressions
  • Replace All


edit flag offensive delete link more

answered 2015-08-04 09:03:01 +0200

JohnSUN gravatar image

Try this

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2015-08-03 22:57:46 +0200

Seen: 82 times

Last updated: Aug 04 '15