SOLVED

Excel Online - Copy and Paste

Copper Contributor

Hello,

I have an issue that I can't seem to get rid of. In a simple spreadsheet where I have a list of people with email addresses and phone numbers, etc, when copying an email address, it now adds the url of the email address to the cell to the right.

This happens online in Excel on the browser and it does not happen if I work on the spreadhseet on the app. Like you see below, the email address shows ok, but the cell next to it "gained" the url as well. I have typed the email address manually, it does the same, and also double clicking the cell first and pasting the email does the same. Not matter how I paste the email address (no trailing spaces I checked too), it create a mailto: link on the cell to the right.

Screenshot 2023-12-12 114648.png

 

 

 

Thank you for any clarification you may give me on this, if there is any.

Paulo

2 Replies
best response confirmed by Paulo_Pereira78 (Copper Contributor)
Solution

@Paulo_Pereira78 

It seems like you are encountering an issue with Excel Online automatically converting email addresses into mailto links and placing the URL in the adjacent cell. While Excel Online can be configured to recognize certain patterns like email addresses and URLs, this behavior may not always be desired. Unfortunately, Excel Online does not have as many options and settings as the desktop version for controlling these automatic conversions…so far I know :smile:.

Here are some suggestions you can try:

  1. Paste Special - Values:
    • After pasting the email address, use the "Paste Special" feature and select "Values" to paste only the text without any formatting.
  2. Format as Text:
    • Before entering or pasting the email address, format the cell as text. This can sometimes prevent Excel Online from automatically converting the entry into a hyperlink.
  3. Clear Formatting:
    • After entering or pasting the email address, select the cell, right-click, and choose "Clear Formatting" to remove any unwanted hyperlink formatting.
  4. Use Excel Desktop Application:
    • If you have access to the Excel desktop application, consider using it for tasks where you need more control over formatting and behavior.
  5. Check for Updates:
    • Periodically check for updates to Excel Online. Microsoft may introduce new features or settings that provide more control over automatic conversions.
    •  

Remember that Microsoft regularly updates its online applications, and the availability of features can change. If the problem persists, checking the most recent documentation or support resources provided by Microsoft might offer more insights. The text and steps were edited with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

Hi, thank you for your response, apologies I forgot to reply, I will use the desktop app for the time being then, I tried everything and just won't work for me, and since it does not happen on desktop app I will use it that way until an update fixes it :) Thank you again.
1 best response

Accepted Solutions
best response confirmed by Paulo_Pereira78 (Copper Contributor)
Solution

@Paulo_Pereira78 

It seems like you are encountering an issue with Excel Online automatically converting email addresses into mailto links and placing the URL in the adjacent cell. While Excel Online can be configured to recognize certain patterns like email addresses and URLs, this behavior may not always be desired. Unfortunately, Excel Online does not have as many options and settings as the desktop version for controlling these automatic conversions…so far I know :smile:.

Here are some suggestions you can try:

  1. Paste Special - Values:
    • After pasting the email address, use the "Paste Special" feature and select "Values" to paste only the text without any formatting.
  2. Format as Text:
    • Before entering or pasting the email address, format the cell as text. This can sometimes prevent Excel Online from automatically converting the entry into a hyperlink.
  3. Clear Formatting:
    • After entering or pasting the email address, select the cell, right-click, and choose "Clear Formatting" to remove any unwanted hyperlink formatting.
  4. Use Excel Desktop Application:
    • If you have access to the Excel desktop application, consider using it for tasks where you need more control over formatting and behavior.
  5. Check for Updates:
    • Periodically check for updates to Excel Online. Microsoft may introduce new features or settings that provide more control over automatic conversions.
    •  

Remember that Microsoft regularly updates its online applications, and the availability of features can change. If the problem persists, checking the most recent documentation or support resources provided by Microsoft might offer more insights. The text and steps were edited with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

View solution in original post