Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://fedia.social/notes/9vqb0idfurzjzayv">clacke@libranet.de is my main (notclacke@fedia.social)'s status on Monday, 15-Jul-2024 17:45:51 JST</a><a href="https://fedia.social/@notclacke" title="notclacke@fedia.social"><img src="https://gnusocial.jp/avatar/173067-48-20230915204822.webp" width="48" height="48" alt="clacke@libranet.de is my main" style="position: absolute; left: 0; top: 0;">clacke@libranet.de is my main</a></section><article><p>Because Reasons I was in Excel. <br><br>I had a dirty table with some links by HYPERLINK() and I just wanted to paste it somewhere else in Excel to clean it up and format it.<br><br>But if you just copy and paste you get broken formulas when references are relative to stuff you're not copying (the raw data). And if you paste special, values only, the hyperlinks lose their linkiness.<br><br>The solution? Paste somewhere not-Excel but still rich text, then copy and paste back to Excel to do formatting. 🤣<br><br>This is the next level of the "paste it to Notepad" trick to strip formatting.<br><br><a href="https://superuser.com/questions/47067/using-paste-special-values-with-the-hyperlink-function-in-excel">superuser.com/questions/47067/using-paste-special-values-with-the-hyperlink-function-in-excel</a></p></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/3377106#notice-6645659">In conversation</a><time datetime="2024-07-15T17:45:51+09:00" title="Monday, 15-Jul-2024 17:45:51 JST">about 7 months ago</time> <span>from <span><a href="https://fedia.social/notes/9vqb0idfurzjzayv" rel="external" title="Sent from fedia.social via ActivityPub">fedia.social</a></span></span><a href="https://fedia.social/notes/9vqb0idfurzjzayv">permalink</a><h4>Attachments</h4><ol><li><article><header><div>Domain not in remote thumbnail source whitelist: cdn.sstatic.net</div><h5><a href="https://superuser.com/questions/47067/using-paste-special-values-with-the-hyperlink-function-in-excel">Using Paste Special &gt; Values with the HYPERLINK function in Excel</a></h5><div></div></header><div>I have a long list of data in Excel 2007. Using the Hyperlink function:=HYPERLINK(C2,A2)
I've added individual links to them all. Now I want to get rid of the function and just leave the data wi...</div><footer></footer></article></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
clacke@libranet.de is my main (notclacke@fedia.social)'s status on Monday, 15-Jul-2024 17:45:51 JST clacke@libranet.de is my main
Because Reasons I was in Excel.

I had a dirty table with some links by HYPERLINK() and I just wanted to paste it somewhere else in Excel to clean it up and format it.

But if you just copy and paste you get broken formulas when references are relative to stuff you're not copying (the raw data). And if you paste special, values only, the hyperlinks lose their linkiness.

The solution? Paste somewhere not-Excel but still rich text, then copy and paste back to Excel to do formatting. 🤣

This is the next level of the "paste it to Notepad" trick to strip formatting.

superuser.com/questions/47067/using-paste-special-values-with-the-hyperlink-function-in-excel
In conversationabout 7 months ago from fedia.socialpermalink
Attachments
1. Domain not in remote thumbnail source whitelist: cdn.sstatic.net
  Using Paste Special > Values with the HYPERLINK function in Excel
  I have a long list of data in Excel 2007. Using the Hyperlink function: =HYPERLINK(C2,A2) I've added individual links to them all. Now I want to get rid of the function and just leave the data wi...

Public

Embed Notice

HTML Code

Corresponding Notice