<div>
Try this formula...<br />
<br />
&nbsp; =IF(LEFT(A1, 1)=&quot;1&quot;, RIGHT(A1, 10), A1)
</div>


Try this formula...

  =IF(LEFT(A1, 1)="1", RIGHT(A1, 10), A1)

<div>
Another way is you can check the length of the string like this.....<br />
Assuming your phone number string is in A2, then try<br />

<pre><code id="code-20-41781063-1">=IF(LEN(A2)&gt;10,RIGHT(A2,10),A2)</code></pre>
</div>


Another way is you can check the length of the string like this.....
Assuming your phone number string is in A2, then try


=IF(LEN(A2)>10,RIGHT(A2,10),A2)

<div>
@Rob<br />
Absolutely perfect. :)
</div>


<div>
Though Rob offered the shortest formula, all the proposed solutions will resolve the question, so point should be split between all the experts.
</div>


Though Rob offered the shortest formula, all the proposed solutions will resolve the question, so point should be split between all the experts.

<div>
<div class="content wysiwyg-content">
I have a column of phone numbers that are 10 or 11 digits. Currently they are formatted as text. Some phone numbers have a 1 in the front, some do not. <br />
<br />
How can I take the 1 out of the phone numbers that have it? That way they are are consistently 10 digits. <br />
<br />
Thanks!
</div>
</div>


I have a column of phone numbers that are 10 or 11 digits. Currently they are formatted as text. Some phone numbers have a 1 in the front, some do not. 

How can I take the 1 out of the phone numbers that have it? That way they are are consistently 10 digits. 

Thanks!

Take 1 out of the phone number

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.