Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-10-2012, 11:47 AM
jeffk jeffk is offline wildcards in find & replace to reverse word order Windows 7 64bit wildcards in find & replace to reverse word order Office 2007
Advanced Beginner
wildcards in find & replace to reverse word order
 
Join Date: Jul 2012
Location: North of England, UK
Posts: 32
jeffk is on a distinguished road
Default wildcards in find & replace to reverse word order

I'm trying to use wildcards in Find & Replace to reverse the order of names in a list from surname, first name e.g.

Blogs Fred --> Fred Blogs
Smith John --> John Smith
Doe John


Etc SoForth

I thought that I needed to select ‘Use wildcards’ & type \1 \2 in the ‘Find what’ field & \2 \1 in the ‘Replace with’ field, but when I do this & click ‘Replace All’ I get an error message:

“The Replace with group text contains a number which is out of range”

What's going on here? What am I doing wrong?

*******************************
Edit:
OK, I just tried (<*>) (<*>) in 'find what' & \2 \1 in 'replace with' & it works as long as I select the list of names first, otherwise it applies to everything in the document & messes up the text.

I'm sure that I've done this in the past & it’s worked without me having to select text first, but I can’t remember how..............any suggestions?

Also, I still don't understand why the first way didn't work & what the error message actually means, so any clarification still welcomed!


TIA

Last edited by jeffk; 11-10-2012 at 01:11 PM. Reason: additional info
Reply With Quote
 

Tags
find & replace, wildcards, word order

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
wildcards in find &amp; replace to reverse word order Word Find and Replace Query bthart Word 1 12-29-2011 12:45 AM
wildcards in find &amp; replace to reverse word order Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
wildcards in find &amp; replace to reverse word order Word 2010: Wildcards Replace tinfanide Word 2 09-10-2011 10:40 AM
Any wildcards search and replace in Powerpoint 2010? tinfanide PowerPoint 0 09-10-2011 02:17 AM
Reverse order of headings throughout Word my_vine_figtree Word VBA 1 08-17-2010 01:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:42 AM.


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