Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-17-2011, 09:19 PM
Griff's Avatar
Griff Griff is offline Find & Replace formula for numbers? Mac OS X Find & Replace formula for numbers? Microsoft Office 2008 for Mac
Novice
Find & Replace formula for numbers?
 
Join Date: Apr 2011
Posts: 3
Griff is on a distinguished road
Default Find & Replace formula for numbers?

Is there a formula for Find & Replace? Specifically for replacing numbers with other numbers?

I have a document with 11 pages of various number combinations that look a bit like this:

A-1, 6, 7, 8
A-3, 8, 1, 2
A-5, 2, 3, 4
A-7, 4, 5, 6

I need to change all the instances of...
"1" to "8"
"2" to "1"


"3" to "2"
"4" to "3"
And so on...

I would do a simple Find & Replace, but by the time I get to the final one (which is changing "8" to "7") the Find function will locate all the "8" including the ones which used to be "1". Get me?

So if there were a function or formula that could just subtract 1 from the value I'd be set.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find & Replace formula for numbers? Help with find and replace or query and replace shabbaranks Excel 4 03-19-2011 08:38 AM
Find and replace page numbers in body of text tollanarama Word 3 02-13-2011 06:00 AM
Find & Replace formula for numbers? replace automatically generated page numbers LitWissOnline Word 3 01-24-2011 03:40 PM
find and replace anil3b2 Word 0 08-03-2010 11:30 PM
Find /Replace Help ilcaa Word 2 11-02-2009 08:41 AM

Other Forums: Access Forums

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