Replace "comma" with "and" in line of text

		Microsoft Office Forums > Microsoft Word > Word VBA
Replace "comma" with "and" in line of text

FAQ

Thread Tools

Display Modes

audioman Replace "comma" with "and" in... 01-12-2016, 01:43 PM

Robert2 You can do it with a wildcard... 01-12-2016, 04:32 PM

macropod Robert: Audioman probably... 01-13-2016, 03:01 AM

audioman You're right macropod. I was... 01-13-2016, 06:02 AM

macropod Try: Sub Demo()... 01-13-2016, 07:43 PM

audioman Hi macropod: I found the... 01-21-2016, 02:01 PM

macropod That's not VBA code. As... 01-21-2016, 02:09 PM

audioman Thanks macropod, I can make... 01-21-2016, 03:11 PM

01-12-2016, 01:43 PM

audioman

Windows 7 64bit Replace "comma" with "and" in line of text

Office 2010 64bit

Novice

Join Date: Mar 2014

Posts: 7

Replace "comma" with "and" in line of text

Need a macro which will scan a word document and find each instance of "apples, oranges, peaches" then replace with "apples, oranges and peaches" and/or find "apples, oranges" then replace with "apples and oranges"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error: "Changes made were lost...reconnect with server", when switching "from" field	randhurrle	Outlook	2	02-25-2015 06:51 PM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
Suppress comma in "city , stat zip" line when blank	DHammer	Mail Merge	1	05-30-2014 02:43 AM
How to edit the "Format" and the "show level" of an EXISTING table of content?	Jamal NUMAN	Word	2	08-14-2011 10:46 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM