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

01-21-2016, 02:01 PM

audioman

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

Office 2010 64bit

Novice

Join Date: Mar 2014

Posts: 7

Hi macropod:
I found the code you provided back in 2014. It's:
Find = ,([!,^13^l]@[^13^l])
Replace = ^32and\1

It worked quite well at that time. I'm now trying to incorporate the code in a macro which will find and replace multiple instances of the name string. I was able to do that in 2014.
Unfortunately, probably due to changes in VBA, I keep getting errors when trying to run this code.
Can you help?

Tags

find & replace, macro in word, office 2010

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:24 AM.