Text with "@" char

%3CLINGO-SUB%20id%3D%22lingo-sub-2139307%22%20slang%3D%22fr-FR%22%3EText%20with%20%22O%22%20tank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2139307%22%20slang%3D%22fr-FR%22%3E%3CP%3EWhy%20does%20excel%20convert%20a%20text%20with%20'''%20into%20a%20hyperlink%2C%20especially%20after%20adding%20a%20double%20quotes.%20Eq.%20%22p%40asdfn55234123412LK%22%20in%20a%20cell%20becomes%20a%20hyperlink.%20Would%20like%20to%20have%20this%20considered%20as%20text%2C%20so%20that%20when%20copied%20could%20retrieve%20it%20with%20double%20quotes%2C%20instead%20presently%20it%20presents%20itself%20as%20p%40asdfn55234123412LK%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2139307%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2139325%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20with%20%22%40%22%20char%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2139325%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F968224%22%20target%3D%22_blank%22%3E%40jhnworks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20thinks%20anything%20with%20an%20%40%20is%20an%20email%20address.%3C%2FP%3E%0A%3CP%3ETo%20prevent%20this%2C%20there%20are%20several%20methods%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EFormat%20the%20cell%20as%20Text%20before%20entering%20a%20value%20containing%20%40.%3C%2FLI%3E%0A%3CLI%3EPrefix%20the%20value%20with%20an%20apostrophe%20'.%3C%2FLI%3E%0A%3CLI%3ETo%20disable%20this%20behavior%20entirely%2C%20select%20File%20%26gt%3B%20Options%20%26gt%3B%20Proofing%20%26gt%3B%20AutoCorrect%20Options...%20%26gt%3B%20AutoFormat%20As%20You%20Type.%20Clear%20the%20check%20box%20'Internet%20and%20network%20paths%20with%20hyperlinks'%20and%20click%20OK.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
New Contributor

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'

5 Replies

@jhnworks 

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.

@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""'

 

@jhnworks 

Try replacing "" with " in the Replace dialog.

@jhnworks 

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

https://support.microsoft.com/en-us/office/remove-or-turn-off-hyperlinks-027b4e8c-38f8-432c-b57f-6c8...

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

@jhnworks 

Can't reproduce that

image.png

How and which exactly value do you enter?