I have a column with URLs, but don't like the appearance of having URLs in this worksheet, so I'd like all the URLs to simply appear as "[Text]". (Choose your preferred word here.)
I know you can make the URL a hyperlink, and then edit that hyperlink's "text to display." The problem there is that if you then try to copy and paste these URLs to another app, they copy as the text, not as the underlying URL.
Similarly, instead of using hyperlink functionality – which I have no use for and prefer to avoid anyway – I tried custom formatting the URL cells using ";;;"[Text]"". But I ran into the same issue I just described; I'm then unable to properly copy and paste the underlying URLs into other apps.
Is there any solution here? I know one approach would be to simply format the URL cells so that the font is white, and thus the cells appear blank, but I'd prefer not to go this path, as I'd like to have something short and simple still appearing in these cells. But not the URLs.
I know you can make the URL a hyperlink, and then edit that hyperlink's "text to display." The problem there is that if you then try to copy and paste these URLs to another app, they copy as the text, not as the underlying URL.
Similarly, instead of using hyperlink functionality – which I have no use for and prefer to avoid anyway – I tried custom formatting the URL cells using ";;;"[Text]"". But I ran into the same issue I just described; I'm then unable to properly copy and paste the underlying URLs into other apps.
Is there any solution here? I know one approach would be to simply format the URL cells so that the font is white, and thus the cells appear blank, but I'd prefer not to go this path, as I'd like to have something short and simple still appearing in these cells. But not the URLs.