D
Dustin D. Cook
How do I use a macro to capitalize the first letter of every sentence?
We are a real estate firm that has to condense our listing write-ups to fit
in various online comment fields. I wrote a macro to abbreviate many words,
remove others, and generally condense the write-up to within about 60% of its
original size while still conveying all of its original information.
However, once my macro has run many of my sentences no longer begin with
capital letters. This is because many of the words that would normally begin
a sentence (e.g. "the", "a", and "this") have been removed to conserve space.
How should I proceed? I will send macro code upon request via e-mail. It is
against our company policy to post it in a public forum.
We are a real estate firm that has to condense our listing write-ups to fit
in various online comment fields. I wrote a macro to abbreviate many words,
remove others, and generally condense the write-up to within about 60% of its
original size while still conveying all of its original information.
However, once my macro has run many of my sentences no longer begin with
capital letters. This is because many of the words that would normally begin
a sentence (e.g. "the", "a", and "this") have been removed to conserve space.
How should I proceed? I will send macro code upon request via e-mail. It is
against our company policy to post it in a public forum.