Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2015, 09:29 PM
arcnap arcnap is offline How to find and replace from next tab Windows 7 64bit How to find and replace from next tab Office 2013
Novice
How to find and replace from next tab
 
Join Date: Feb 2015
Posts: 1
arcnap is on a distinguished road
Default How to find and replace from next tab

Hi,



I am trying to use find and replace to solve a huge problem in thousand of pages. How can I change Replace Signage - Push: None to Refer to Signage Sheet globally

It is a little bit tricky because none is in the another column and there are some other none in entire document which need to stay. Please see the attached image.

I wonder is there a way to jump next column while using find and replace tool for example:

Find: Signage - Push: "TAB" None

Replace: Signage - Push: "TAB" Refer to Signage Sheet

Please see the image

Thanks a lot
Reply With Quote
  #2  
Old 02-03-2015, 11:00 PM
macropod's Avatar
macropod macropod is offline How to find and replace from next tab Windows 7 64bit How to find and replace from next tab Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

You can't do that via Find/Replace using Replace All. Unless you use a macro, which would be worth the effort for an infrequent requirement, the best you can do is use a Find for 'None' and selectively replace/retain the found occurrences.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
find and replace



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find and replace from next tab VBA Batch Find & Replace for all MSOffice extensions, to replace File Name and Content of the File QA_Compliance_Advisor Word VBA 11 09-11-2014 11:51 PM
How to find and replace from next tab 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/Find and Replace Loop Tango Mike Word 3 04-20-2014 02:47 PM
How to find and replace from next tab Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
How to find and replace from next tab Help with find and replace or query and replace shabbaranks Excel 4 03-19-2011 08:38 AM

Other Forums: Access Forums

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