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

[PeterCapek]

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.

[PYS]

Hi - AutoCorrect +1

And to convert cells that already contains @:

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

Regards

[JohnSUN]

Try this