snipt

Ctrl+h for KB shortcuts

Text only

Format phone numbers in spreadsheet

="("&MID(A2,1,3)&") "&MID(A2,4,3)&"-"&MID(A2,7,4)
https://snipt.net/embed/0ee096b8f97db2d0d292beaf628cee5a/
/raw/0ee096b8f97db2d0d292beaf628cee5a/
0ee096b8f97db2d0d292beaf628cee5a
text
Text only
1
2019-07-16T03:55:44
True
False
False
/api/public/snipt/12812/
format-phone-numbers-in-spreadsheet
<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>=&quot;(&quot;&amp;MID(A2,1,3)&amp;&quot;) &quot;&amp;MID(A2,4,3)&amp;&quot;-&quot;&amp;MID(A2,7,4) </span></pre></div> </td></tr></table>
"phone numbers", format, spreadsheet