W
WillBeau
My question is: how to identify consecutive captial letters (ideally,
entirely capitalized words) in a string --- either by using Edit/Find or by
writing a VBA subroutine.
BACKGROUND
To prepare a large text file for import into MS Access, I need to locate the
lines of text that contain a word (any word) that is entirely capitalized ---
or, alternately, contain at least three consecutive capital letters. This
Edit/Find task would be part of a macro that would then insert paragraph
breaks at the start of such capitalized lines of text.
I tried a variety of wild card and format criteria to find capitalized words
(any capitalized word) in Edit/Find, but none worked. For example, ^$^$^$
with format property of ALL CAPS did not work for me.
For simplicity, I'd prefer to use Edit/Find, but I have working knowledge of
VBA if I must write a subroutine. Thanks for considering my question.
entirely capitalized words) in a string --- either by using Edit/Find or by
writing a VBA subroutine.
BACKGROUND
To prepare a large text file for import into MS Access, I need to locate the
lines of text that contain a word (any word) that is entirely capitalized ---
or, alternately, contain at least three consecutive capital letters. This
Edit/Find task would be part of a macro that would then insert paragraph
breaks at the start of such capitalized lines of text.
I tried a variety of wild card and format criteria to find capitalized words
(any capitalized word) in Edit/Find, but none worked. For example, ^$^$^$
with format property of ALL CAPS did not work for me.
For simplicity, I'd prefer to use Edit/Find, but I have working knowledge of
VBA if I must write a subroutine. Thanks for considering my question.