Snipt.net is closing on December 31st, 2016

For more information, please visit this blog post.

snipt

Ctrl+h for KB shortcuts

Text only

excel to html table

http://pressbin.com/tools/excel_to_html_table/index.html
https://snipt.net/embed/49a630f7e10f09a0dc3b8e52f8e3cc08/
https://snipt.net/raw/49a630f7e10f09a0dc3b8e52f8e3cc08/
49a630f7e10f09a0dc3b8e52f8e3cc08
text
Text only
1
2016-12-04T23:24:20
True
False
False
Jan 20, 2014 at 03:22 AM
/api/public/snipt/107111/
excel-to-html-table
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>http://pressbin.com/tools/excel_to_html_table/index.html </span></pre></div> </td></tr></table>
excel, html

Text only

excel remove trailing slash

=IF(ISNUMBER(FIND("/",MID(A2,LEN(A2)-1,LEN(A2)+1))),MID(A2,1,LEN(A2)-1),A2)
https://snipt.net/embed/0588411143eee8a18c405229a3b512a7/
https://snipt.net/raw/0588411143eee8a18c405229a3b512a7/
0588411143eee8a18c405229a3b512a7
text
Text only
1
2016-12-05T07:33:14
True
False
False
Nov 21, 2013 at 07:13 AM
/api/public/snipt/95749/
excel-remove-trailing-slash
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>=IF(ISNUMBER(FIND(&quot;/&quot;,MID(A2,LEN(A2)-1,LEN(A2)+1))),MID(A2,1,LEN(A2)-1),A2) </span></pre></div> </td></tr></table>
excel

Text only

Excel 2010 replace last character condition

=IF(RIGHT(A1;1)="-";LEFT(A1;LEN(A1)-1);A1)
https://snipt.net/embed/fb4a438b051f7b7e625ac3c47cea2aa3/
https://snipt.net/raw/fb4a438b051f7b7e625ac3c47cea2aa3/
fb4a438b051f7b7e625ac3c47cea2aa3
text
Text only
1
2016-12-04T23:26:08
True
False
False
/api/public/snipt/63008/
-3658
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>=IF(RIGHT(A1;1)=&quot;-&quot;;LEFT(A1;LEN(A1)-1);A1) </span></pre></div> </td></tr></table>
excel, replace
Copyrighted, illegal, or inappropriate content? Email [email protected].