Numbers Removal in a brackets

ranjan · #3 05-20-2022, 12:21 AM

Hi Macropod,

Its working fine but am facing small issue with this code. code is completely removing the text within the brackets having numbers..

Ex: If total is presented in negative value then its completely deleting the total value..

I want to delete the text having +,- or both combination withint the brackets.

Total (2345,99) This shouldnt be removed, but my code was removing the total value also, is there any possibility to remove text in the brackets having +,- or both combination.

Input:

ABC (1255+3456-211+4332)
DEF (123+456+678)
GHI (123-456-678)
TOTAL (123,456)

Output:

ABC
DEF
GHI
TOTAL (123,456)

Could you please review the below one:

Code:

Sub Test_Replace()
    With ActiveDocument.Content.Find
        .Text = "\(*\)"
        .Replacement.Text = ""
        .ClearFormatting
        .Replacement.ClearFormatting
        .MatchWildcards = True
        .Execute Replace:=wdReplaceAll
    End With
End Sub

Your Help is Highly Appreciated...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2019: How to display the sign of numbers in another field in brackets?	Jamal NUMAN	Excel	3	09-16-2021 09:44 AM
Need Wild Card for Deleting Square Brackets with Differing Numbers inside	CrossReach	Word	6	11-26-2019 01:02 PM
Bold numbers between square brackets	jeffreybrown	Word	4	02-13-2017 04:32 PM
Help with: Replace and reformat numbers inside square brackets	johnbrowny	Word	1	02-13-2016 06:45 PM
Find and Replace - How to insert brackets around all numbers in a doc	Natedogg	Word	2	05-21-2015 07:16 AM