Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2014, 08:27 AM
WordUser2015 WordUser2015 is offline Find and replace BETWEEN numbers Mac OS X Find and replace BETWEEN numbers Office for Mac 2011
Novice
Find and replace BETWEEN numbers
 
Join Date: Dec 2014
Posts: 3
WordUser2015 is on a distinguished road
Smile Find and replace BETWEEN numbers


Hello, I want to replace periods in between numbers with colons, in a MS Word document. i.e. 23.5; 14.16; 16.9 -- to -- 23:5; 14:16; 16:9.

In the FIND box I've put ([0-9]).([0-9]) and it finds the instances in the document where a period appears between numbers, but I haven't figured out what goes in the REPLACE box to get this done. Any ideas?
Reply With Quote
  #2  
Old 12-18-2014, 07:08 PM
macropod's Avatar
macropod macropod is offline Find and replace BETWEEN numbers Windows 7 64bit Find and replace BETWEEN numbers Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Try a wildcard Find/Replace, where:
Find = ([0-9]).([0-9])
Replace = \1:\2
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-19-2014, 07:51 AM
WordUser2015 WordUser2015 is offline Find and replace BETWEEN numbers Mac OS X Find and replace BETWEEN numbers Office for Mac 2011
Novice
Find and replace BETWEEN numbers
 
Join Date: Dec 2014
Posts: 3
WordUser2015 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Try a wildcard Find/Replace, where:
Find = ([0-9]).([0-9])
Replace = \1:\2
I've tried using the \1:\2 formula but it does not work. It will swap the numbers around and put the colon behind them.

1.5-7 will end up 15:7
Reply With Quote
  #4  
Old 12-19-2014, 01:45 PM
macropod's Avatar
macropod macropod is offline Find and replace BETWEEN numbers Windows 7 64bit Find and replace BETWEEN numbers Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

The swapping around suggests you have 'Track Changes' on - it has nothing to do with the Find/Replace expression as such, which works just fine.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-19-2014, 02:09 PM
WordUser2015 WordUser2015 is offline Find and replace BETWEEN numbers Mac OS X Find and replace BETWEEN numbers Office for Mac 2011
Novice
Find and replace BETWEEN numbers
 
Join Date: Dec 2014
Posts: 3
WordUser2015 is on a distinguished road
Default

Thank you very much! I did have my Tracking changes button ON. As soon as I turned it OFF I was able to make the changes with the provided formula.

I made over 1400 changes in the document.

Thanks again!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and replace BETWEEN numbers Find what box in Find and replace limits the length of a search term Hoxton118 Word VBA 7 06-10-2014 05:05 AM
find and replace consecutive numbers kpl_39 Word 1 06-07-2013 05:04 AM
Find and replace BETWEEN numbers Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
Find and replace BETWEEN numbers Find & Replace formula for numbers? Griff Word 4 04-18-2011 02:47 AM
Find and replace page numbers in body of text tollanarama Word 3 02-13-2011 06:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 AM.


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