Filtering by a word contained in a cell

RandDsnow

New Member
Joined
Jul 7, 2004
Messages
11
Does anyone know how to filter, in a query, by a certain word contained any where inside the cell?

Thanks for any help
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

pritcham

Board Regular
Joined
Oct 26, 2005
Messages
128
Hi

If you mean anywhere in a particular field then if you add something like the following to the criteria box in query designer:

Like "*WhatImLookingFor*"

The key is to a) use the "Like" keyword, and b) surround what you're looking for with * which is the wildcard character.

Hope that helps
Martin
 

Watch MrExcel Video

Forum statistics

Threads
1,119,273
Messages
5,577,144
Members
412,769
Latest member
VK12345
Top