|First, let's get the terminology right. |
re: "I need is an excel macro that I can put in the column"
A macro can not be "put in the column". A macro is group of instructions that is stored in the VBA editor. The macro can place values/text/formulas etc. in the column, but the macro itself is not "put in the column".
That said, based on the example data you have provided, you do not need a macro. You can extract the text between the brackets with 2 built-in Excel functions: MID and FIND.
If you need an explanation on how that works, just let us know.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.