VBA: loop in cells and delete bracket content

[Nelson78]

Hello everybody.

I'm looping in a range:

For Each cell In Sheets(2).Range("F2:F" & lr3)
   '....
Next cell

For each cell in this range, I need, if existent brackets with exactly 2 characters as a content, delete the brackets and its content.

For example:

LONDON (LD)

has to be turned into

LONDON

BERLIN (BL) GERMANY

has to be turned into

BERLIN GERMANY

But

ROME (ITALY)

has to stay unchanged because of 5 charachters and not 2 into the brackets.


Can you support me?

Thank's.

 

[Fluff]

No need for a loop, you can do it like

  Sheets(2).Range("F2:F" & LR3).Replace "(??)", "", xlPart, , , , False, False

 

[Fluff]

If you always have a space before & after the brackets, use this instead.

  Sheets(2).Range("F2:F" & LR3).Replace " (??)", "", xlPart, , , , False, False

 

[alansidman]

For the cells in question, are the only values the city and the bracketed information? Or, is there other information in the cells also. Can you provide a sample of 5-10 cell values showing all possible type of combinations so that we can provide a viable solution.