Replace given text and variable number

In certain lines in my document I have the text 'NUMBER: ' followed by a number of variable length.

I'd like to use Find and Replace code to remove the text 'NUMBER: ' and the following number wherever it appears.

So , for example the lines

SEAL - FLY LIKE AN EAGLE
126730BX320 NUMBER: 9067

SOUL FOR REAL - EVERY LITTLE THING I DO
166044BX90 NUMBER: 58453393

SPACEHOG - IN THE MEANTIME
159298BX192 NUMBER: 68229

ASWAD - DON`T TURN AROUND
27947BX111


would become

SEAL - FLY LIKE AN EAGLE
126730BX320

SOUL FOR REAL - EVERY LITTLE THING I DO
166044BX90

SPACEHOG - IN THE MEANTIME
159298BX192

ASWAD - DON`T TURN AROUND
27947BX111


Can someone suggest some code to satisfy this?

I'll attach a sample file.


Grateful for any advice.

I suggest you first do a format cleanup to make your data consistent. You are using at least three different formats, which makes this harder.

Do a Find and Replace
Check the box for "Use wildcards"

For numbers followed by a paragraph mark:

Find:

Formula:

Please Login or Register  to view this content.

Replace:

Formula:

Please Login or Register  to view this content.

For numbers followed by a manual line break:

Find:

Formula:

Please Login or Register  to view this content.

Replace:

Formula:

Please Login or Register  to view this content.

For numbers followed by a tab then a manual line break:

Formula:

Please Login or Register  to view this content.

Replace:

Formula:

Please Login or Register  to view this content.

Replace All

I may have missed some variations.

6StringJazzer - Many thanks for your help. I ran the Find and Replace rules you suggested and found it clears the majority.

Sorry it not as straightforward as we'd have liked. I'm still trying to clear the lines with

NUMBER: 819180

NUMBER: 849120

in the sample file.

windknife - thanks. That clears all target references.

Thanks guys - problem solved!

Originally Posted by windknife

Another way,

1. Ctrl+H
2. More>>
3. Checked 「Use wildcards」
4. Find what: NUMBER*[^l^13]
5. Replace with: ^l
6. Replace All

Nothing succeeds like success! I was trying to avoid a solution that would wipe out any text that would follow the numbers. Sometimes examples can be deceiving. If numbers are always the last thing on the line, then this is a great solution.