Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2013, 06:43 AM
kpl_39 kpl_39 is offline find and replace consecutive numbers Mac OS X find and replace consecutive numbers Office 2013
Novice
find and replace consecutive numbers
 
Join Date: Jun 2013
Posts: 1
kpl_39 is on a distinguished road
Default find and replace consecutive numbers

I am making labels using a stock Avery Label Template.



One part of the label has a text string with a number.

Variable #1

This goes on consecutively on each label until "label 150" shows "Variable #150".

I want to make a new set of labels from Variable #151 to Variable #300 by running a find and replace on my set of labels Variable #1 to Variable #150.


Is there any way to do this?

Thanks
Reply With Quote
  #2  
Old 06-07-2013, 05:04 AM
macropod's Avatar
macropod macropod is offline find and replace consecutive numbers Windows 7 32bit find and replace consecutive numbers Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,384
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

A Find/Replace operation can't do that on its own.

An alternative would be to replace all the 'Variable #' strings with a combination of 'Variable #' and a SEQ field, so that Word can handle the numbering automatically. To do this:
1. Select the first number, delete it, press Ctrl-F9 and type 'SEQ Nr' between the field braces, thus {SEQ Nr}.
2. Copy the entire 'Variable #{SEQ Nr}' range.
3. Do a wildcard Find/Replace, where:
Find = Variable #[0-9]{1,3}
Replace = ^c
4. Press Ctrl-A, then F9 to update.
You should now have a complete set of consecutive numbers.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
find and replace consecutive 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 consecutive numbers Find & Replace formula for numbers? Griff Word 4 04-18-2011 02:47 AM
find and replace consecutive 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
Consecutive page numbers on multiple documents georgeeasten Word 1 02-10-2011 02:12 AM

Other Forums: Access Forums

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