Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How can I remove links from a table?

Brian.Martinez
Brian.Martinez February 18, 2020

I have a spreadsheet with 217 rows.  One of the columns has folder paths that include ".com".  Because of that, all of the paths have a link.  I need to be able to remove the links or prevent the automatic link creation.  How can I do this?

Answer
Watch
Like Victor Mutambuki likes this
1123 views

1 answer

0 votes
Victor Mutambuki [Mumo Systems]
Victor Mutambuki
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
February 18, 2020

Brian,

Please see link below.
https://www.thespreadsheetguru.com/blog/find-remove-external-links-from-excel-spreadsheet

Victor

View More Comments
Brian.Martinez
Brian.Martinez February 18, 2020

They are not links in the spreadsheet. They are just plain text.  When I copy and paste into a table on my confluence page, it treats the FQDN in the cell as a URL. I'm assuming because of the .com.

Like
Victor Mutambuki [Mumo Systems]
Victor Mutambuki
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
February 18, 2020

Brian,

Do a search, find and remove the .com

Victor

Like
Reply

Suggest an answer

Log in or Sign up to answer
Confluence
Confluence
TAGS
AUG Leaders

Atlassian Community Events

    See all events