Thread: [Solved] Regex-pattern
View Single Post
 
Old 01-01-2025, 01:18 PM
vivka vivka is offline Windows 7 64bit Office 2016
Expert
 
Join Date: Jul 2023
Posts: 293
vivka is on a distinguished road
Default

While Paul's code does the job perfectly, I can propose a regex code to match any number of only first-upper-cased-letter words between two commas:
Code:
,(\s[A-Z][a-z]+)+,
I am really grateful to Paul (and gmayor, gmaxey, guessed, Italophil, to name just some of the experts on this forum) who are real vba gurus who kindly and patiently share their immense knowledge.

Last edited by vivka; 01-02-2025 at 12:45 PM.