Is there a formula or a macro that can take this string -
311[BCE]308[N]

And parse out the data that is contained in the brackets [....] ?

For example:

311[BCE]308[N] BCE N


Where Col A is the string, and Col B and Col C are the results of the
parsing.

Thanks in advance.