Hi, all. Just looking for a little bit of help. I'm working with reports where, in Column A, I have a species name in round brackets, such as (Phoca vitulina) followed by its associated species code, which is also in round brackets (1365).

I want to change only the species code in this column so that it is contained within square brackets [1365] without changing the brackets surrounding the species name.

Can this be accomplished using the find and replace tool? Thanks in advance.