Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-27-2019, 09:53 AM
kilroy kilroy is offline Reversing Word Order with Multiple String Types Windows 10 Reversing Word Order with Multiple String Types Office 2016
Competent Performer
 
Join Date: Sep 2016
Location: Southern Ontario
Posts: 122
kilroy is on a distinguished road
Default

Try this:

Find: ([A-Z]. [A-Z]. )([A-Z]{1}[a-z]{1,}-[A-Z]{1}[a-z]{1,})------(works for R. M. Johnson-Hulk – run first)
Replace: \2, \1

Find: ([A-Z]. )([A-Z]{1}[a-z]{1,}-[A-Z]{1}[a-z]{1,}) -----(worksfor M. Johnson-Hulk –run second)
Replace: \2, \1

Find: ([A-Z][. ]) ([A-Z][. ]) ([A-Z]{1}[a-z]{1,}) ----(Worksfor R. M. Johnson – run third)
Replace: \3, \1, \2

Find: ([A-Z]. )([A-Z]{1}[a-z]{1,}) -----(Works for J. Smith– run last)
Replace: \2, \1


Last edited by kilroy; 06-27-2019 at 01:15 PM. Reason: spacing
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change multiple pictures in Word 2016 to all new pictures that appear in a specified order? chaz Word VBA 7 07-11-2018 03:57 AM
Reversing Word Order with Multiple String Types Replace multiple strings by one same string at once puff Word 2 02-28-2018 11:04 AM
How to do multiple find and replace in string. PRA007 Word VBA 2 01-06-2016 09:10 PM
multiple types of alignment on one line? uoficowboy Word 1 03-06-2010 08:54 PM
Reversing Word Order with Multiple String Types Reversing Text Order weemikey Word 4 08-05-2009 11:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft