Find Near (2000/SP3)

Topic

New Reply

User wants to find any cell in a Word table that contains “fed*” and “statement”. Do Boolean operators work in a Word find? If not, how would we set up this search, to find those two words in a cell, but not necessarily sequential?

Thanks in advance.

Reply | Quote

Replies

The user could do a wildcard search for fed*statement, but this will only find the text if statement comes after fed in the cell, and it won’t find Fed*statement, for wildcard searches are case sensitive.

You could write a macro that loops though the cells of the table and uses InStr to check whether fed and statement are present in the cell.

Reply | Quote