Need Word Macro to Delete Text

rsrasc · #1 04-18-2018, 07:27 AM

Hi all,

I have a document with over 500 pages. and I would like to be able to delete all the text between the word DOLLAR VALUE and the information after that.

Here is how the information is showing in the document:

HTML Code:

 
BRITTANY 1
 
    SICK LEAVE   REGULAR HOURS                            7.50                 77.50                      40.25
 
    ANNUAL LEAVE REGULAR HOURS                            7.50     19.75
                 DOLLAR VALUE
 
KARIN 1
 
    SICK LEAVE   REGULAR HOURS       4.00                14.75      7.50      286.00
 
    ANNUAL LEAVE REGULAR HOURS       5.75                21.25                261.25   89.25
                 DOLLAR VALUE       65.44                                    2973.03
 
LACOURTNEY 1
 
    SICK LEAVE   REGULAR HOURS                                                 14.50
 
    ANNUAL LEAVE REGULAR HOURS                59.50                59.50
                 DOLLAR VALUE                631.30*
 
ALYSSA 1 
 
    SICK LEAVE   REGULAR HOURS       3.50                15.00                105.25
 
    ANNUAL LEAVE REGULAR HOURS       3.50                15.00                 37.75
                 DOLLAR VALUE       37.49                                     404.30

Here is how the information should looks after applying the macro:

HTML Code:

BRITTANY 1
 
    SICK LEAVE   REGULAR HOURS                            7.50                 77.50                      40.25
 
    ANNUAL LEAVE REGULAR HOURS                            7.50     19.75
 
 
KARIN 1
 
    SICK LEAVE   REGULAR HOURS       4.00                14.75      7.50      286.00
 
    ANNUAL LEAVE REGULAR HOURS       5.75                21.25                261.25   89.25
 
 
LACOURTNEY 1
 
    SICK LEAVE   REGULAR HOURS                                                 14.50
 
    ANNUAL LEAVE REGULAR HOURS                59.50                59.50
 
 
ALYSSA 1 
 
    SICK LEAVE   REGULAR HOURS       3.50                15.00                105.25
 
    ANNUAL LEAVE REGULAR HOURS       3.50                15.00                 37.75

So, basically I would like to have a macro so I can delete the word DOLLAR VALUE and any numbers after that word but not deleting the next letter or name available

As always, thank you in advance for your assistance and cooperation.

Regards!

slaycock · #2 04-18-2018, 02:32 PM

You don't need a macro. A wildcard search and replace should so the job.

Guessed · #3 04-18-2018, 03:44 PM

Search and replace for
DOLLAR VALUE*^13
with Wildcards turned on

macropod · #4 04-18-2018, 04:27 PM

I'd be inclined to use a wildcard Find/Replace where:
Find = ^13[!^13]@DOLLAR VALUE*^13
Replace = ^p
That'll delete the leading spaces in the 'DOLLAR VALUE' lines as well.

rsrasc · #5 04-18-2018, 11:32 PM

Thank you all for your responses, and the wildcard Find/Replace did the job.

Excellent. Much appreciated.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to delete text in specific styles	ljd108	Word VBA	14	01-22-2019 01:22 PM
Macro to delete rows not containing specific text	Alimou	Excel Programming	4	02-06-2017 07:35 AM
Macro to delete text from cells with specific format	Soenke	Word VBA	4	09-01-2016 08:55 AM
Microsoft Word macro to find text, select all text between brackets, and delete	helal1990	Word VBA	4	02-05-2015 03:52 PM
Macro Delete Selected Text	smonczka	Word VBA	2	11-05-2011 03:18 AM