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 [....] ?

Are each of those numbers always going to be 3-digits long? If not, will one
of them always 3-digits long (if so, which one)?

Rick Rothstein (MVP - Excel)