Thread: [Solved] Find and replace text with wildcards
View Single Post
 
Old 06-27-2019, 08:40 AM
arunchandar9 arunchandar9 is offline Windows 7 32bit Office 2013
Banned
  
Join Date: Jun 2019
Posts: 8
arunchandar9 is on a distinguished road
Default Find and replace text with wildcards
Hi,

How to find below red highlighted text and replace it using Wildcards

With .Range.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = ""
.Execute Replace:=wdReplaceAll

Three scenarios - 1) Text with Aphanumberic with special characters 2) Text is in second row and sometimes partial with 1st row and second row 3) There is no Vertical bar (|) to pin point specific text



1 73181500 SCREW (200 NOS) | AB_1234K123
2 73269099 PLATE (16 NOS) |
PL_3617A026
3 73181500 0S1573 BOLT
Last edited by arunchandar9; 06-27-2019 at 02:45 PM.
Reply With Quote