This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Sorry if this appears not as forthcoming as some other replies, but i believe very much in giving people the right tools to self-educate them.
What you want to achieve is superbly documented in the Find Replace example. Click on the tool in the tool bar and select Open example. here is a snippet of the workflow that opens up - and the first case use does exactly what you want, just the other way round - from & to AND...
Find and Replace is looking for the exact text you enter in the input stream. As such if you enter in the column word <space>AND<space>
(leading and trailing space), it will achieve what you wanted.