Boolean search - AND, NOT, and OR

**nobleprince** · 01-05-2019, 09:32 PM

Hi,

I would like a macro that allows me to use the following keywords: “, AND, NOT, and OR during my search of a text file.

Could someone please develop the macro?

See below for full explanation:

https://www.linkedin.com/help/linked...nkedin?lang=en

**Leith Ross** · 01-05-2019, 10:48 PM

Hello nobleprince,

What are you searching: Workbook, Worksheet, Range, Text files, or Web sites? Please be more specific and provide before and after examples if the macro will make changes to the data.

**nobleprince** · 01-06-2019, 05:37 PM

Hi Leith,

Thanks for your message.

To further clarify the requirements, I want to be able to type searches in Sheet1 (e.g. A2, and the output should appear in B2, B3, etc). The Macro should search for words from the Words worksheet using the AND, OR, NOT and () Boolean search. Parenthetical () searches - I should be able to combine terms using parentheses. See cell A6 in worksheet Sheet1.

Please see attached excel 2016 spreadsheet.

I look forward to your solution.

Thanks in advance.