title: Excel Formula for removing leading 1 on phone number if present
body: <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>