I have an Excel spreadsheet where cell A1 contains the following string of text:
[text] more text (even more text)
I want cell B1 to contain:
and cell C1 to contain:
(even more text)
Repeat for the rest of the rows.
Basically, for column B I need some formula to parse column A text, search for text inside square brackets and copy it along with the brackets. Same thing for column C, except the text in this column has to be the one inside curved brackets, along with the brackets, of course.
I'm an Excel noob. Cheers.