Macro to swap words in a comma-separated list

M

Malcolm Patterson

Given a sentence like the following:

Someone is watching every Tom, Harry, and Dick as they pass the storefront.

How can I use a wildcard search to find

Harry, and Dick

and replace it with

Dick, and Harry

This happens often enough that I want to record a macro.
 
P

Paul B

Given a sentence like the following:

Someone is watching every Tom, Harry, and Dick as they pass the storefront.

How can I use a wildcard search to find

Harry, and Dick

and replace it with

Dick, and Harry

This happens often enough that I want to record a macro.
Click to expand...


Find: (Harry)(, and )(Dick)

Replace: \3\2\1

p.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
2007 Macro for repairing comma separated issue 0
Counting word occurences: a VBA code gives wrong count 1
how can I use Word find and Replace to search inside a stringvariable (in a macro) 1
A search macro with search data stored in a separate TXT file 9
Word Macro for multiple searches, incl. in footnotes 2
Merging Macros 1
Macro to save word pages separately as PDF and name them according to text in third line 0

Top