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.

Try this Wildcard replace
Find: \(([0-9]{3,})\)
Replace with: [\1]

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia