title: Remove characters in Excel
body: <p>I'm exporting a list from SharePoint online that exports lookup columns and their ID which is impossible to change.</p>
  
  <p>On Export, this is what it looks like:</p>
  
  <p><a href="https://i.stack.imgur.com/OwcNz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OwcNz.png" alt="enter image description here"></a></p>
  
  <p>Is there a way that I can write an Excel function to delete specific characters combinations? I would like something similar to this <code>;#(Number between 1-2000)#</code> and <code>;#(Number between 1-2000)</code> to be deleted.  </p>
  
  <p><a href="https://i.stack.imgur.com/Dcqca.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Dcqca.png" alt="enter image description here"></a></p>