Microsoft Office Forums - View Single Post - [Solved] Remove parenthesis that contain four digits or etal word vba

Thread: [Solved] Remove parenthesis that contain four digits or etal word vba

View Single Post

Old

10-30-2023, 06:57 AM

vivka

vivka is offline

vivka uses Windows 7 64bit

Windows 7 64bit vivka uses Office 2016

vivka uses Office 2016

Office 2016

Expert

Join Date: Jul 2023

Posts: 293

vivka is on a distinguished road

Default

Hi! I think Andrew just accidentally included asterisks (It was a simple overlook, I'm sure, because his knowledge of VBA is immense). Try this to delete years in parentheses:

Code:

\([0-9]{4}\)

Last edited by vivka; 10-30-2023 at 12:52 PM.

Reply With Quote