Extracting Text after a character - but ignoring if character is blank

Hi All

I'm trying to make an Excel file more consistent with it's data and in particular I have the following Issue.

COLUMN A - COLUMN B
Germany (DE) - DE
Great Britain (GBR) GBR
United States (USA) - Romania (ROM)


For Column A I have done the following - =RIGHT(AL2,LEN(AL2)-SEARCH("(",AL2)) - It now only shows the data after the Brackets - WORKING.
Column B though, If I use the same formula, on rows where there are no brackets it states #VALUES

But the issue is, in this Column, if there's no Brackets I want to leave it alone and show the data (in this example, if there's no brackets, then it definitely has the short code), whilst for values where there are Brackets, I want it just follow the originally formula.

Hope this makes sense - I tried to put it into a table but the option is greyed out.

I think you can solve this with an IFERROR() function

My Guess without example file would be:

Formula:

Please Login or Register  to view this content.

Absolute legend! That works a treat!

One drawback in my file is that it doesn't include the Opening Brackets in the output cell, so I'm just using CONCATENATE to put it in.

Another thing I could do is remove the end Brackets and would I be on the right lines to nest a LEN formula that gets rid of one character from the right?

(I tried to add the document but it's not working in Chrome nor Edge)

One drawback in my file is that it doesn't include the Opening Brackets in the output cell, so I'm just using CONCATENATE to put it in.

Use this: =IFERROR(RIGHT(A2,LEN(A2)-SEARCH("(",A2)+1),"") you will get (DE) or (GBR)

Another thing I could do is remove the end Brackets and would I be on the right lines to nest a LEN formula that gets rid of one character from the right?

To get only DE or GBR use this formula: =IFERROR(SUBSTITUTE(MID(A2,FIND("(",A2)+1,LEN(A2)),")",""),"")

Thank you