Feb 16 2021 06:08 AM - edited Feb 16 2021 06:26 AM
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, so that when copied could retrieve it with double quotes, instead presently it presents itself as 'p@asdfn55234123412LK'
Feb 16 2021 06:22 AM
Excel thinks anything with an @ is an email address.
To prevent this, there are several methods:
Feb 16 2021 06:38 AM
@Hans Vogelaar 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="p@asdfn55234123412LK"' instead of 'ManuValue=""p@asdfn55234123412LK""'
Feb 16 2021 06:46 AM
Try replacing "" with " in the Replace dialog.
Feb 16 2021 07:30 AM
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)
Feb 16 2021 12:04 PM