#1
|
|||
|
|||
Changing Certain Brackets in Column
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. |
#2
|
||||
|
||||
Try this Wildcard replace
Find: \(([0-9]{3,})\) Replace with: [\1]
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and delet all text within brackets and the brackets themselves | ranjan | Word VBA | 2 | 07-22-2021 01:06 AM |
Pagination when changing from 2 to 1 column | Brewer52 | Word | 2 | 09-16-2020 02:27 PM |
find and delet all text within brackets and the brackets themselves | wrdy | Word | 2 | 08-03-2017 06:55 PM |
Column Width keeps changing | alsmith | Word Tables | 1 | 05-25-2013 02:09 AM |
changing column formats | herbycanopy | Excel | 2 | 03-30-2010 09:11 PM |