Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2020, 07:41 AM
jeffreybrown jeffreybrown is offline Replace abbreviated word with full name Windows 10 Replace abbreviated word with full name Office 2016
Expert
Replace abbreviated word with full name
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default Replace abbreviated word with full name


I'm getting close, but missing the right syntax

I have...

Rev1:
Rev2:
etc.
Rev22:

I would like to replace with

Revelation 1:
Revelation 2:
etc.
Revelation 22:

Find what: (Rev)([0-9]{1,2})
Replace with: Revelation \1 \2
Reply With Quote
  #2  
Old 10-31-2020, 11:59 AM
Charles Kenyon Charles Kenyon is offline Replace abbreviated word with full name Windows 10 Replace abbreviated word with full name Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,467
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Replace with: "Revelation \2"
Without the quotation marks.
Make sure you have "Use Wildcards" checked.
Reply With Quote
  #3  
Old 10-31-2020, 12:43 PM
macropod's Avatar
macropod macropod is offline Replace abbreviated word with full name Windows 10 Replace abbreviated word with full name Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,370
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For example:
Find = (Rev)([0-9])
Replace = \1elation \2
or:
Find = Rev([0-9])
Replace = Revelation \1
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 10-31-2020, 03:32 PM
jeffreybrown jeffreybrown is offline Replace abbreviated word with full name Windows 10 Replace abbreviated word with full name Office 2016
Expert
Replace abbreviated word with full name
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Thanks to the both of you. All these suggestions worked great.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace abbreviated word with full name Using find and replace to insert an extra space after full stops Johanna Word 33 03-07-2020 01:43 PM
Replace abbreviated word with full name How to return the full string (entire word) when searching with wildcards in word vba scienceguy Word VBA 13 03-23-2019 03:27 AM
Replace abbreviated word with full name Table of Figures/Tables with Abbreviated captions zapp7 Word 1 07-23-2016 04:14 PM
Abbreviated first name Mulith Mail Merge 1 11-03-2014 04:26 AM
Replace abbreviated word with full name how to replace a full paragraph with blanks? dylansmith Word 8 10-22-2012 11:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:14 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