title: How to replace every existing values of a column with formula?
body: <p>My sheet already has data. Unfortunately, later I realized that all the values in column E should be validated and changed as necessary by calling my own user-defined function and passing the values as the function parameter. For example, say I have the following data in column E:</p>
  
  <pre><code>E1: "This is a text in (E1)"
  E2: "This is a text in (E2)"
  ...
  E7000: "This is a text in (E7000)"
  </code></pre>
  
  <p>Now, I want every value in column E to be changed by a formula like this:</p>
  
  <pre><code>E1: = RemoveBrackets("This is a text in (E1)")
  E2: = RemoveBrackets("This is a text in (E2)")
  ...
  E7000: = RemoveBrackets("This is a text in (E7000)")
  </code></pre>
  
  <p>Supposing Excel supports Regex, my problem can be solved easily. but unfortunately Excel doesn't. Could someone propose possible solutions to my problem?</p>
  
  <p>Thanks in advance</p>