Forum Discussion
jhnworks
Feb 16, 2021Copper Contributor
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,...
jhnworks
Feb 16, 2021Copper Contributor
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"""'
SergeiBaklan
Feb 16, 2021Diamond Contributor