Extracting Text Between Brackets

Hi

I have a column with a series of sentences generated from a server. After the word "Problem" it then gives an error code between square brackets, i.e.

"Problem in Error [55143] please check in [ABCD]"

The error codes between square brackets are of diff lengths, and I need to export into a diff column the value between the square brackets AFTER the word "Error" (not the latter one). Is this possible please?

Wow, brilliant! Of course my next question will be, is it possible to extract the second set of square brackets into a diff column please?

Hi,

I have been able to use these formulas and it perfectly worked. Thanks.

I'm now looking to update and improve it to match the following requirement, but I did not succeed:

In my cell, I have the following character string
Please have a look to (my problem) and to (T+ 12000) and (T+ 12500)

I would like to export the text inside parenthesis, but only when it starts with T+.

Thanks

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.