title: Remove www. from domains in excel
body: <p>Ive got a list of urls in column A, some of them have <code>www.</code> some dont, (none of them have <code>http://</code> in this example)</p>
  
  <p>What im trying to do is strip the <code>www.</code> do ive got a list of domains that i can order alphabeticly. I was looking at using <code>=RIGHT(A1, LEN(A1)-4)</code> but not all the domains have <code>www.</code> Any idea how you would be able to do this using a formula, rather than VBA so that it can run in both excel and Google Drive ?</p>
  
  <hr>
  
  <p><strong>EDIT</strong></p>
  
  <p>Ive now updated the example spreadsheet with Alex Szabó's answer - <a href="https://docs.google.com/spreadsheets/d/1x-zjaIh7xpGeyWPbYLAn5RyNjbrDWFQdI_U5WmS3fys/edit#gid=0" rel="nofollow">https://docs.google.com/spreadsheets/d/1x-zjaIh7xpGeyWPbYLAn5RyNjbrDWFQdI_U5WmS3fys/edit#gid=0</a></p>