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.
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