How to suppress double ".." at the end of a sentence when a name ends "Inc."

dfolzenlogen · #1 04-03-2022, 06:22 PM

If there have been previous posts regarding this issue, I apologize. I could not find them. I have a mail merge and many, but not all, of the "owners" are companies ending with "Inc." in their names. The mail merge setup has a sentence ending with a merge field of the Owners' name. How do I suppress the "." in the Owner name if it is followed by text which is a "." so that the sentence does not end with ".."?

The same field is used several places in the document so would not need to suppress the "." in every instance.

Thanks in advance.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro	Matt C	Excel Programming	2	01-08-2022 06:03 AM
Combine "sort within groups" and "identify duplicate/unique values" in two different variables.	civilcervant	Excel	3	06-12-2017 07:27 AM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
Replacing a single "l" with a double "ll"	MShroff	Word	8	01-19-2011 08:43 AM