Forum Discussion
Text with "@" char
Why does excel convert a text with '@' into a hyperlink, especially after adding a double quotes. eq. "p@asdfn55234123412LK" in a cell becomes a hyperlink. Would like to have this considered as text,...
Excel thinks anything with an @ is an email address.
To prevent this, there are several methods:
- Format the cell as Text before entering a value containing @.
- Prefix the value with an apostrophe '.
- To disable this behavior entirely, select File > Options > Proofing > AutoCorrect Options... > AutoFormat As You Type. Clear the check box 'Internet and network paths with hyperlinks' and click OK.
HansVogelaar Going with the last option/(Remove auto correct). However, now we see that all the manipulated values having "". How does one remove these after copy.
Would like to see 'ManuValue="mailto:p@asdfn55234123412LK" instead of 'ManuValue=""mailto:p@asdfn55234123412LK"""'
Try replacing "" with " in the Replace dialog.
