#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
Tags |
find and replace |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |
Bad view when using Find and Find & Replace - Word places found string on top line | paulkaye | Word | 4 | 12-06-2011 11:05 PM |
Help with find and replace or query and replace | shabbaranks | Excel | 4 | 03-19-2011 08:38 AM |