How do I extract only the ETSS from between the brackets and place those 4 characters in a new column?
As you may also notice, typically, but not always, there is a space on either side of the characters between the brackets.
EQUIPMENT SUPPLIERS, INC [ ETSS ]
More examples of my project of extracting characters from between brackets are as follows:
FRANKLIN MANUFACTURING [FMI ]
GILLETTE FENCE MANFACTURING [ GF ]
GLOBAL INDUSTRIES [ GLES ]
MACHOVEC [ MC ]
Bookmarks