Hi,

Please accept my apologies for the inconvenience caused by the ambiguity in the above thread.

The document contains specific text with values that I would like to extract.

Ex: String “Alpha” is presented 230 time in a document Such as “Alpha” followed by running text presented 225 times & “Alpha” followed by the values presented 5 times. I want to extract “Alpha” with values only.

Searching “Alpha” will take more time over the document and having a chance of skipping the value.

Would it be possible to have a macro that tags "Alpha" with only values (“0-9”, “ ,” “-”, “.”)

Simply to tag specify text having only values or " “– " (Null values) or to tag specific text followed by other than Alphabets I.e. (“0-9”, “ ,” “-”, “.”)

Ex 1:

Input:

Alpha 325,073,525.57 168,023,239.06 4,299,873.55 152,750,412.96
Alpha -- 32,992,309.96 -- 36.70% 2,856,936.33
Alpha 137,469,744.75 130,686,669.60

Output:

@@Alpha 325,073,525.57 168,023,239.06 4,299,873.55 152,750,412.96
@@Apha -- 32,992,309.96 -- 36.70% 2,856,936.33
@@Alpha 137,469,744.75 130,686,669.60

Ex 2:
In the below paragraph string “Alpha” shouldn’t get tagged because the text “Alpha” doesn’t having any value.

The data of “Alpha”, indigo and XN software packages (1) in the report
From the chart it (2) that “Alpha” (3) the highest annual saving. However, the
training cost of this software (4) the highest among all the three software packages.
Purchase price of XN (5) the highest though its savings __ (6) lower than “Alpha”.

It would be greatly appreciated if you could assist me in this regard.