Excel Formula for removing leading 1 on phone number if present
<p>I am needing to create a formula that removes the leading 1 from a 11 digit phone number as shown below. </p>

<p>I would also like the formula to exclude any 10 numbers that doesn't have a leading 1.</p>

<p>I am trying to have my list all the same with just 10 digits.</p>

<p><a href="https://i.stack.imgur.com/8vyq9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8vyq9.png" alt="enter image description here"></a></p>