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,...
With the permission of everyone involved, here is some additional information from Microsoft.
remove the hyperlink
In Excel:
If the hyperlink was created using the HYPERLINK function, you can remove the hyperlink by using the following steps:
Select the cell containing the hyperlink.
Press CTRL+C to copy the hyperlink.
Right Click and paste using the Values paste option.
Remove all hyperlinks at the same time
In Excel 2010 and later:
Select all cells that contain hyperlinks, or press Ctrl+A to select all cells.
Right-click, and then click Remove Hyperlinks.
Microsoft Info: Remove or turn off hyperlinks
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)