title: Extract and Copy text between characters in excel
body: <p>I am looking for a way to extract text between 2 characters and copy them to a column at the end of the spreadsheet.</p>
  
  <p>For example, my text looks like [abcdefg], all in Column A,  I am looking to extract the text between the "[" and copy it to a new column at the end of the worksheet (as a new column)</p>
  
  <p>Thanks</p>