How to remove all characters that are not between square brackets?

Sorry if this is a repost but all the posts I was finding on how to achieve what I'm looking for offered the inverse of what I was after.

• There is a table with hundreds of thousands of rows.
• Two columns contain text.
• Within that text there are characters between square brackets, sometimes more than more than one square bracketed text per line.

How does one go about removing all characters that are not between square brackets (thus keeping all the text between the square brackets only)?

(Please be gentle, taking excel beyond just tables is relatively new to me.)

UPDATE: there are more than one square brackets in a line of text & I am using either Exel2016 or 2019 desktop versions.

SOLUTION UPDATE:

• Enter Power Query > Add Column > Custom Column
• Remember to change [YourColumnName] to the Column you wish to extract the Square Brackets and their Bracketed text From

​

Text.Combine( List.Transform( Text.Split([YourColumnName], "["), each if Text.Contains(_, "]") then "[" & Text.BeforeDelimiter(_, "]") & "]" else "" ) )