Thread: [Solved] Remove parenthesis that contain four digits or etal word vba
View Single Post
 
Old 10-31-2023, 06:21 AM
vivka vivka is offline Windows 7 64bit Office 2016
Expert
  
Join Date: Jul 2023
Posts: 293
vivka is on a distinguished road
Default
The code I proposed [.text = " \([!\)]@[0-9]{4}*\)"] works perfectly on your sample text: it removes parentheses with years plus text, leaving intact (2016) and (AgNPs).
Reply With Quote