A program that I am writing works from Extracts from several Excel Worksheets. I can import the data but because the Excel worksheets require manual input of the names of companies. Therefore, there are errors like this
Currently, I do a sort of entries by company name and examine them manually. Can anyone suggest a query or a function that uses regular expressions to automate the identification of these items? I have searched the forum, but did not find it on my own.
Thanks,
Alan
Code:
A J MULLINS
AJ MULLINS
BARRICK GOLDSTRIKE MINE INC
BARRICK GOLDSTRIKE MINES INC
BLACK STONE MINERALS
BLACKSTONE MINERALS
CUNNINGHAM, PAUL
CUNNINGHAM, PAUL S
"DOUBLE ""D"" NEVADA LLC"
DOUBLE D NEVADA LLC
GREFCO INCORPORATED
GREFCO INCORPORTATED
H K VEAL & CO
H K VEIL & CO
Currently, I do a sort of entries by company name and examine them manually. Can anyone suggest a query or a function that uses regular expressions to automate the identification of these items? I have searched the forum, but did not find it on my own.
Thanks,
Alan