I would like to ask for your help, with the below. So far, I only found a solution that extracts the first required string, but ignores the rest of them in a cell.
Starting data (each row represents separate cell in a column):
This is a [table]. [Table] has four [legs] and a board. On the table, you can put a [plate], [fork] and [knife] [Anything] Version of the table is [2.0]. There can by [any val_ues12] in brackets
I need to extract all the values in the square brackets to separate cells and include the square brackets. For the above example, it would be great if there was a second sheet created with following cells:
[table] [Table] [legs] [plate] [fork] [knife] [Anything] [2.0] [any val_ues12]
A link to sample Excel containing formula I currently have:
See the screenshot of sample Excel:
Can anyone help with this, please?