snipt

Ctrl+h for KB shortcuts

Text only

Generate formatted phone number for use in spreadsheets (e.g. 1111111111 to (111) 111-1111)

="("&LEFT(L3,3)&") "&MID(L3,4,3)&"-"&RIGHT(L3,4)
https://snipt.net/embed/d0b9d385b6fac1d06053f4248cc7fadf/
/raw/d0b9d385b6fac1d06053f4248cc7fadf/
d0b9d385b6fac1d06053f4248cc7fadf
text
Text only
1
2019-07-16T04:25:49
True
False
False
/api/public/snipt/6603/
generate-formatted-phone-number-for-use-in-spreadsheets-eg-1111111111-to-111-111-1111
<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;LEFT(L3,3)&amp;&quot;) &quot;&amp;MID(L3,4,3)&amp;&quot;-&quot;&amp;RIGHT(L3,4) </span></pre></div> </td></tr></table>
"phone number", format, spreadsheet